Topic Options
#33478 - 10/01/10 12:52 PM Cannot remove decimals from imported Xcel database
Greko1 Offline
OL Newbie

Registered: 10/01/10
Posts: 7
Loc: Michigan, USA
I'm using Printshop 6.1 on PC (Win XP service pack 3) and when I import the database all my variables that are numbers 1, 2, 3, etc appear and print like this: 1.00, 2.00, 3.00 etc. I found an old post saying to use the REPLACE expression and I still get unwanted decimals and zeroes. I've even tried changing my Xcel spreadsheet numbered columns to "text" and I still get the same result. Any ideas?

Top
#33479 - 10/01/10 12:54 PM Re: Cannot remove decimals from imported Xcel database [Re: Greko1]
Raphael Lalonde Lefebvre Offline
OL Expert

Registered: 10/14/05
Posts: 4953
Loc: Objectif Lune Montreal
Greko1,

Place the number on your page. Then, go to the Variables tab(or in the menu Window->Variables) and highlight the variable that contains the number. Go to it's properties(Window->Properties) and there either set the number of decimals to 0, or change the variable's type to Text.

Hope that helps!

Regards,
Raphaƫl Lalonde Lefebvre

Top
#33481 - 10/01/10 01:50 PM Re: Cannot remove decimals from imported Xcel database [Re: Raphael Lalonde Lefebvre]
Greko1 Offline
OL Newbie

Registered: 10/01/10
Posts: 7
Loc: Michigan, USA
That did it. Thank you!

Top