Excel worksheet problem

[John]

I have got a very weired problem for Excel worksheet.
When I type a number such as 8, the worksheet
automaticlly displays 0.08. It seems the worksheet
calculates the typed number divided by 100. I have tried
to "format cell", and doesn't work. Does someone have
clue how I configure the Excel worksheet to
normal?
My Excel version is small business 2000.

Thanks in advance for your suggestion.

Reagrds,

 

[JE McGimpsey]

Tools/Options/Edit uncheck the Fixed decimal places checkbox.

 

[Norman Harker]

Hi John!

Use:
Tools > Options > Edit
Remove check from Fixed decimals

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Debra Dalgleish]

You can find the solution to that problem in the Excel
FAQs:

http://www.contextures.com/xlfaqApp.html#FixedDec

'===================
When I type a number, example 44, it becomes 0.44 even if
I format the cell without decimals.

Go to Tools>Options/Edit and uncheck the Fixed decimals
checkbox
'========================

 

[Daryl]

-----Original Message-----
I have got a very weired problem for Excel worksheet.
When I type a number such as 8, the worksheet
automaticlly displays 0.08. It seems the worksheet
calculates the typed number divided by 100. I have tried
to "format cell", and doesn't work. Does someone have
clue how I configure the Excel worksheet to
normal?
My Excel version is small business 2000.

Thanks in advance for your suggestion.

Reagrds,

.
Go into the format cells, and click on number.Select the

number category, and set your decimal places to zero. This
should take care of the problem.