Topic Options
#24730 - 04/13/10 08:05 PM stripping cents from dollar amounts
pspdfppd Offline
OL Newbie

Registered: 11/16/09
Posts: 22
Loc: mississauga, ontario, canada
Hi

we have a job where the artwork is laid out showing dollar values in even dollar ammounts ie: $50

The excel file we received has decimals.. ie: 50.00 which is not good because it's requiring more space than is available. (an extra 2 zeros per data field x3)

I'm not sure if we can stip out the .00 part in printshop mail or if this is something that can be handled in exel itself. there are no dollar ammounts in fractions... ie: 50.75 just even numbers like 50.00 (always .00 following the numbers.)

Any help would be appreciated.

Top
#24731 - 04/14/10 09:38 AM Re: stripping cents from dollar amounts
shaja Offline
OL Newbie

Registered: 05/14/07
Posts: 13
Loc: Lake Geneva, WI, USA
You can do it in Excel or in PrintShop Mail, whichever way you choose, but I think PrintShop Mail is faster.

In PrintShop Mail: make sure you have the Properties window open. In the Variables tab, click on your variable to highlight it. Go to the Properties window, and in the Format drop-down menu pick Currency. You will then get several fields to format your variable, including how many decimal places to use.

Top
#24732 - 04/14/10 10:56 AM Re: stripping cents from dollar amounts
Anonymous
Unregistered


pspdfppd,

You could also set the Category of the variable to "Text", and then in your expression, you would strip it:
REPLACE([Field], ".00", "")

Regards,
Eric.

Top
#24733 - 04/17/10 11:00 AM Re: stripping cents from dollar amounts
pspdfppd Offline
OL Newbie

Registered: 11/16/09
Posts: 22
Loc: mississauga, ontario, canada
thanks for the help, we're up and running now

Top