Excel-Formatting numbers (All you Experts)?

Question

I have formatted several columns of cells as a "Whole Number", with no decimal places.
Even though formatting this way, when entering a number,
"2", etc., the number is entered as "0.02" ,a decimal.
I do not want to enter as "text". They won't SUM.
$%^%*^, I've used Excell for several years. What in H is happening?
This has only occurred in the past couple months.

I'm considering re-installing Excell in hopes it will restore the default formatting from original CD, Office 2003.

Is this my only option?

I understand formattig "0" decimals.
None so far has helped. I used my original CD, and used the "Repair" function. Still didn't work.

The only way I can enter a whole number
is, "Enter "2.0", with formatting "0" decimals. Never had this problem for years.
Even several old existing files are doing this.
General and Custom does not work.
I don't mind the inconvenience myself, but I've built new files for someone else.

Would appreciate any other suggestions
Thanks.

I should add, since it's displaying decimals, 0.02 instead of a whole number, when I format 0 decimals, it rounds down to 0. So entering 2 displays 0. Arrrggggg.

Sorry blueeyes. Good suggestions but all is in order. Didn't help.
I reinstalled Excell, still no help.

Answer 1

It's hard to say without knowing a little more. Do you have the cell formatted as a percentage? If so that could be one reason.

There are two other possible things I can think of;

Go to Tools > Options...

Then under the Calculation tab see if Iteration is checked. If it is, then uncheck it.

The last thing I can think of is if somehow your computer settings are messed up rather than just Excel.

Go to your Control Panel in windows and select the Regional and Language Options. Select the Regional Options tab on the window that comes up. To the left of where the customize button is, English (United States) should be listed, provided you live in the US. If that is not selected, make that your selection. If it is, then click the Customize button.

You should have the following categories and values under the Number tab:

Decimal symbol: . (period)
No. of digits after decimal: 2
Digit grouping symbol: , (comma)
Digit grouping: 123,456,789
Negative sight symbol: -
Negative number format: -1.1
Display leading zeros: 0.7
List separator: , (comma)
Measurement system: U.S.
Standard digits: 0123456789
Digit substitution: None

Under the Currency tab you should have:

Currency symbol: $
Positive currency format: $1.1
Negative currency format: ($1.1)
Decimal symbol: . (period)
No. of digits after decimal: 2
Digit grouping symbol: , (comma)
Digit grouping: 123,456,789

The commas and periods I added the parenthesis part in case you had trouble distinguishing the two. (comma) & (period) are not part of the values. These are what my settings are for windows with my Excel working fine. So you might consider changing your settings to the same if any of the values are different on your computer.

There is one last thing that I can think of. It may or may not work. If you have XP, you could try doing a restoration to an earlier point. Restore to a point before you started experiencing problems with Excel. A restoration can be undone, but I don't like doing one unless I have to.

If you still have trouble after that, it might be a good idea to call the Microsoft help line.

Answer 2

Commonly Used Number Formats


Commonly used number formats include adding percent symbols ( % ), commas ( , ), decimal places, and dollar signs( $ ).


As mentioned, number formatting is attached to the cell and not to the value in the cell.

If you select a cell containing a number formatted for currency, the plain number, the one used in calculations, is displayed in the formula bar.

Number format can be apply to a single cell, entire columns or rows, a select range of cells.

Try my best to help u. All know from my teacher taught me.

Answer 3

It should leave 2 as 2 when u format it as number with 0 decimals, if you are having problem try the format "General" and see

Answer 4

format cell as number, and set decimal places to 0.

Answer 5

this is a long shot, but what if you use the 0.00<-- icon at the top of the Excel function bar for that cell. That might help.