Excel worksheet problem

  • Thread starter Thread starter John
  • Start date Start date
J

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,
 
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.
 
-----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
Click to expand...
number category, and set your decimal places to zero. This
should take care of the problem.
 
Back
Top