T
T''Kai
Does anyone know how to format currency so that it shows without dollar sign
or commas or decimals (without rounding up)
example: $3,059.63 would convert to 305963 and $25.50 would convert to 2550
I've figured out how to get rid of the dollar sign and the comma, but when I
try removing the decimal the number always rounds up.
This is needed for a fixed length file. The system assumes the last 2 digits
to be cents.
Any help would be appreciated.
Thanks you.
or commas or decimals (without rounding up)
example: $3,059.63 would convert to 305963 and $25.50 would convert to 2550
I've figured out how to get rid of the dollar sign and the comma, but when I
try removing the decimal the number always rounds up.
This is needed for a fixed length file. The system assumes the last 2 digits
to be cents.
Any help would be appreciated.
Thanks you.