all the cells in excell put 2 decimal points in all numbers no ma.

G

Guest

i have to put 5 diget numbers in excel i format the cell to general and i get
a number with 2 decimal points for me to enter 68555 i have to enter it as
68555.00 to get it to due away with the decimal point i reinstalled excel
2ooo but i can't seam to get it to go back to what it use to be. this problem
justed popped up . never did this before
 
B

Bob Umlas

Sounds like you need to turn off fixed decimals, if I understand your
problem. Use Tools/Options/Edit and deselect Fixed Decimals.
Bob Umlas
Excel MVP
 
G

Guest

Bob Umlas said:
Sounds like you need to turn off fixed decimals, if I understand your
problem. Use Tools/Options/Edit and deselect Fixed Decimals.
Bob Umlas
Excel MVP
Click to expand...
 
G

Guest

Bob Umlas said:
Sounds like you need to turn off fixed decimals, if I understand your
problem. Use Tools/Options/Edit and deselect Fixed Decimals.
Bob Umlas
Excel MVP
Click to expand...
 
G

Guest

Thanks you Bob! I had the same problem and it was driving me crazy. I don't
know how the fixed decimals got turned on in the first place.

HC Rogers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Decimal Points in cells 3
Decimal Point... 4
why 2003 excell does not accept dot as decimal points 1
Formula to identify decimal versus whole numbers 12
Decimal points data not displaying as expected 2
Lining up decimal points with negatives in brackets 2
Numbers changing between sheets 13
Unable to line up decimal points in some columns. 3

Top