View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
T''Kai T''Kai is offline
external usenet poster
 
Posts: 2
Default Formatting Currency Without Any Special Characters

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.