Frontpage
Forums
Tutorials
Members
Calendar
Subscription
Donate
Links
Contact 
Help
what went wrong in cell formating if cell shows number (example) 1000 as 1000.0 after i select option "use 1000 separator."? the problem is same after i select other similar options within cell formating...
i not use english version of excel 2000, so is it problem with regional setup?
Page 1 of 1
cell format in excel 2000
Rate Topic:
Back to top
#2
- Junior
-
- Group: Banned
- Posts: 80
- Joined: 13-October 03
Posted 16 March 2004 - 08:07 PM
you need to put '0' in the Decimal places box so that 1000.00 shows up as 1000
The 1000 separator puts a ',' after every 3 digits so 1000000000 (1 billion) shows up as 1,000,000,000
The 1000 separator puts a ',' after every 3 digits so 1000000000 (1 billion) shows up as 1,000,000,000
#3
Posted 17 March 2004 - 07:16 AM
i'm afraid that you didn't understand. i know that puts dots (in my region options are . instead of ,) but problem is not here. even when i put "0" in that box, wrong format is displayed. if there is "2 in decimal box, number with "1000 separator" looks like this: xxxx.0.00 where the x is some number...with "0" number looks like this: xxx.0. so...problem remains 
Share this topic:
Page 1 of 1