Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using 1000 sperator without specifying decimal places
Hello,
I would like to use the 1000 sperator but I don't want to specify fixed decimal places. For example, if the cell contains the number 300, I want it to show 300 and not 300.00, but I still wan't to use the 1000 sperator. How do I do that? The "General" formatting showes the decimal places like I want (only if exists) but does not allow 1000 sperator and the "Number" formatting requires defining a fixed number of decimal places. Thanks, Roee. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal Places | Excel Discussion (Misc queries) | |||
Max decimal places | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
decimal places | Excel Discussion (Misc queries) | |||
add 2 decimal places | Excel Discussion (Misc queries) |