How can I format a value as currency?

[pacel]

Hi,

If my data contains an 11 digit negative value like:

-000000002976

and the intended result should be $29.76, can this be accomplished in the data mapper?

When I try and do this in data mapper, I can only get -2976.00. I’m wondering if I need to divide the value by 100 to get the desired output.

Thanks for any help with this.

Lou

[Phil]

Actually, if you divide by -100, you’ll get a positive currency value.