I am running Excel 2000. The cell format is set to Number with 2 decimal
places. When I enter a whole number without a decimal point it
automatically displays the number by divided by 100, e.g. if I enter 25 it
displays 0.25. This only happens in this one spreadsheet.

Apparently I've set a switch somewhere but I can't find it. Any ideas?

Thanks in advance.

Dave B

Toolsoptionsedit, deselect fixed decimal places


--
Regards,

Peo Sjoblom



"Dave B" wrote in message
. ..
I am running Excel 2000. The cell format is set to Number with 2 decimal
places. When I enter a whole number without a decimal point it
automatically displays the number by divided by 100, e.g. if I enter 25 it
displays 0.25. This only happens in this one spreadsheet.

Apparently I've set a switch somewhere but I can't find it. Any ideas?

Thanks in advance.

Dave B

From the Excel main menu:
<tools<optons<Edit tab
UNcheck: Fixed Decimal places

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Dave B" wrote:

I am running Excel 2000. The cell format is set to Number with 2 decimal
places. When I enter a whole number without a decimal point it
automatically displays the number by divided by 100, e.g. if I enter 25 it
displays 0.25. This only happens in this one spreadsheet.

Apparently I've set a switch somewhere but I can't find it. Any ideas?

Thanks in advance.

Dave B