Software

Ask something
Question Locked

Excel 2003 - Cell format problem in application

0 helpful
7 replies

by lynn

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Using Excel 2003. Cell is formatted as number. There is no formula applied to the cell(s). User enters a number and it is automatically divided by 100. This happens in every excel spreadsheet,new or old. Number goes in ok if the cell is formatted as text. Have uninstalled and reinstalled excel, but does not eliminate the problem. You can open excel in safemode and it does work correctly.

How can I fix this problem so we do not have to work in safemode?

7 replies

by lynn

Looked at that option. It did not work. Did find the answer though. Tools/Options/Edit uncheck fixed decimal. Thank you for your assistance.

by madrem

Go to tools, options , edit and in the fixed decimal places change the value to "0". This should take care of the problem. Your current value is likely to be 2 since your numbers are getting divided by 100.

by maureen.mcgrath

Thanks for the advice. I experienced the same problem, found your solution and solved it! It was quite frustrating when it seemed to just start doing this one day. I thought my PC would need an exorcism!

by michaelpatrickkenny

It's funny, I just solved the same problem. I had been trying to update my settings to eliminate the annoying formatting box that appears every time I cut n Paste and did not understand what that option meant, promptly forgot what I did, and thought I had a virus or something!

I had to post because you posted a mere two days ago, both of us years after the question was first posted!

This discussion is closed to new replies.