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.

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.