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

G

Guest

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.
 
G

Guest

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
Excel defaulting to 3 decimal places when using the gen. format 1
How do I set Excel cell format to "Text" from VB.NET? 8
Insert a note in excel and it appears when the mouse is over the c 4
a comment box that only displays when the cell is actually selected 5
Understanding the Cell Microprocessor [VERY LONG] 12
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) 0
Upgrade Report [GeekTech: Double Your Fun With a Second Monitor - 04/19/2005] 1

Top