Numbers getting cut off

[Karen]

Suddenly my co-worker's excel has gone wacky. He is running Excel 2002 on a windows xp computer. The power went off last night and perhaps it is part of the problem. Suddenly, when he enters a number - say 10000 and hits enter the number is changed to 100. We have checked the formatting and it is in general format. I tried a detect and repair with no luck. Any suggestions?

Thank you,

Karen

 

[Peo Sjoblom]

Tools>options>edit and uncheck fixed decimal places

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)


Suddenly my co-worker's excel has gone wacky. He is running Excel 2002 on a
windows xp computer. The power went off last night and perhaps it is part
of the problem. Suddenly, when he enters a number - say 10000 and hits
enter the number is changed to 100. We have checked the formatting and it
is in general format. I tried a detect and repair with no luck. Any
suggestions?

Thank you,

Karen

 

[Karen]

Thank you! That was the problem. I guess somehow the power surge changed
that option. Weird!
Karen
Tools>options>edit and uncheck fixed decimal places

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)


Suddenly my co-worker's excel has gone wacky. He is running Excel 2002 on a
windows xp computer. The power went off last night and perhaps it is part
of the problem. Suddenly, when he enters a number - say 10000 and hits
enter the number is changed to 100. We have checked the formatting and it
is in general format. I tried a detect and repair with no luck. Any
suggestions?

Thank you,

Karen

 

[Peo Sjoblom]

Karen,

it was not the power surge but he probably opened someone else's workbook
that had
that turned on, if you do that as the first workbook all workbooks opened
after that will have
the same setting, also next time you open excel it will still have that
setting.

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)