Quick and easy question about the Currency data type 1

[Magnus53]

Hi everyone

Sorry for asking this again if it's already been asked before.

I have a a online ordering apllication that i'm modifying to use a 3rd party credit card processing system. The transaction amount is stored as a Currency data type. When testing today I noticed that the cent velaue gets truncated if it's a even dollar amount, such as $40.00. It'll get truncated to $40. I have to have the cent amount.

Is this the default behaviour for the Currency data type? Is there anyways to change this easily? Or should I just change the type?


Thanks

 

[MattSTech]

look into the format function

format(myCurrency,"#000.00") or something like that, no time to test


Matt