You will have to multiply by 100 in a helper column, something like =A1*100
If needed, you can then format that column as 0 decimals. Copy this column,
and paste special as values, then delete the original column
--
Hth

Kassie Kasselman
Change xxx to hotmail


"T''Kai" wrote:

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.