Why is Excel inserting a decimal when the cell format is general?

L

Lisa

My Excel seems to have a glitch. When I set the cell formatiing to general,
Excel insists in placing a decimal point in the figure. 2005 becomes 20.05.

This is true for new documents as well as historic documents in any added
cells. I have recently upgraded to Office 2003. I did not take note if this
began prior to that upgrade or not.
 
K

Kassie

Hi Lisa

Click on Tools|Options, select Edit, and untick the Fixed Deciaml places
option
 

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

General Cell Format changed to Date for all Cells 1
Decimal point in general format 1
Formatting currency with the cents but without the decimal point 2
Decimal places in mail merge 1
New issue with cell formatting 2
pivot table loosing decimals (vba) 1
general formatting numbers in excel 1
when I type numbers in a cell it changes it to a decimal point 4

Top