Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Special Characters | Excel Worksheet Functions | |||
Special Characters | Excel Discussion (Misc queries) | |||
special characters (little box) | Excel Discussion (Misc queries) | |||
special characters | Excel Worksheet Functions | |||
Special characters | Excel Worksheet Functions |