PDA

View Full Version : Unusual Excel Problem


MarcusMel
14th February 2006, 17:39
My Father is typing 1000 into the Excel cells and then presses enter. The result is 10. Type 1009 and the result is 10.09. Another words it Divides by 100 what ever you type in.

The % key is off. When you turn it on the 10 becomes 1000%

Have tried uninstalling Office and reinstalling but the problem still remains.

Have tried a system restore but it says there have been no chages.

When you look at the undo typing it asks if you want to undo the typing of 1000:doh

Have look carefully at all the menu option and can see nothing.

Bet you cant solve this VERY REAL and ANOYING problem.
presto
14th February 2006, 17:42
format cell.
select number.
then how you want it to be displayed (ie, decimal places. 1000 or 1000.0 etc)
MarcusMel
14th February 2006, 17:50
Nope done that still Divides by 100 on input
mathare
14th February 2006, 18:03
The cell formatting is not set to % then?

Does it do this in every cell of every sheet? What about if he opens a new blank spreadsheet?
MarcusMel
14th February 2006, 18:06
Applies to new Blank Sheet -yes - reinstalled office in order to try and get rid of it.
MarcusMel
14th February 2006, 18:07
Yes to every cell - but not when you type the decimal point. on a whole number.
MarcusMel
14th February 2006, 18:21
Ahhhhh - solved it, Well done dad.
mathare
14th February 2006, 18:30
And the solution was... ?
MarcusMel
14th February 2006, 18:33
:D - Go on guess :D
mathare
14th February 2006, 18:35
:D - Go on guess :DYou're mean :wink
MarcusMel
14th February 2006, 18:49
You're mean :wink

But I bet you lot could not solve it! :doh
John
14th February 2006, 20:29
You formatted the cells as TEXT?
John
14th February 2006, 20:30
Either that or you multiplied every whole number entered by 100.
markwales
14th February 2006, 20:37
He was using Word
MarcusMel
14th February 2006, 20:38
No to all suggestions given.
GlosRFC
15th February 2006, 21:33
Sounds to me like he managed to set the Fixed Decimals option...if memory serves me right, it's in Tools, Options, Edit. Check the Fixed Decimals option then use the drop-down list to determine how many decimal places to use.

To be honest, I'm not even sure why this "feature" is provided except in those very rare instances when you might not have a numeric keypad on your keyboard.
MarcusMel
15th February 2006, 22:11
Gloss WINS :D
GlosRFC
15th February 2006, 22:34
No surprises there then :wink