stripping cents from dollar amounts

Posted by: pspdfppd

stripping cents from dollar amounts - 04/13/10 08:05 PM

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.
Posted by: shaja

Re: stripping cents from dollar amounts - 04/14/10 09:38 AM

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.
Posted by: Anonymous

Re: stripping cents from dollar amounts - 04/14/10 10:56 AM

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.
Posted by: pspdfppd

Re: stripping cents from dollar amounts - 04/17/10 11:00 AM

thanks for the help, we're up and running now