 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / May 2008Numerical data does not appear as entered
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: intel When I enter a number in a cell it enters as 1/100th of the value entered. For instance if I type in 10000 and hit enter, 100 shows up in the cell > Version: 2008 > Operating System: Mac OS X 10.5 (Leopard) > Processor: intel > > When I enter a number in a cell it enters as 1/100th of the value entered. > For instance if I type in 10000 and hit enter, 100 shows up in the cell Preferences/Edit, uncheck the "Display this number of decimal places" checkbox (which was a boneheaded renaming of XL04's "Fixed decimal places" preference). In Excel> Preferences> Edit either set the Display this Number of Decimal Places value to 0 or clear the check altogether.  SignatureHTH |:>) Bob Jones Office:Mac MVP > Version: 2008 > Operating System: Mac OS X 10.5 (Leopard) > Processor: intel > > When I enter a number in a cell it enters as 1/100th of the value entered. > For instance if I type in 10000 and hit enter, 100 shows up in the cell Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: intel I have the same problem. It looks like that it happens only when formatting the cell as currency or accounting. I also tried to change "Display this number decimal places" value, but brought me some weird results. See what happens when I put "1": Decimal places => Result 3 => .0,10 2 => .1,00 1 => .10,00 0 => .100,00 (same as unchecked) -1 => 1.000,00 -2 => 10.000,00 -3 => 100.000,00 My regional settings are ok. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.