Cell Format Problem

[brunkel]

When I enter 3 into a cell, it returns .03. What can I do?

[danj34]

2003
Select the cell in question then click

Edit >> Clear >> Formats

[danj34]

2003
Select the cell(s) in question and then click

Edit >> Clear >> Formats

[brunkel]

I'm using Excel 2007, and there doesn't appear to be any 'Edit/Clear/Formats' button? All I did was highlighted the cells, and went to Data/Format/and entered a number with no decimals, but it didn't help?

[tigertiger]

+ Press Office button --> then press Excel options button

+ Select Advances

+ Uncheck option Automatically insert a decimal point

-------
see more information about Automatically insert a decimal point (Ref: Ms.help in excel 2007)

Automatically insert a decimal point Select this check box to display a number with decimal points by default.

Places Enter the number of decimal places in the Places box to indicate where Microsoft Office Excel automatically places the decimal point in the numbers that you type as constants on a worksheet. A positive number moves the decimal point to the left; a negative number moves the decimal point to the right. If the Places box is left blank or is set to 0 (zero), you need to enter the decimal point manually. To override this option, type a decimal point in the cell when you type the number.

[brunkel]

I did what you recommended, but now when I insert a numeric value in a cell, and go to another cell, the original cell has 0 in it?