I type in 1 and it comes up as 0.01

S

Siegi

If I type in any number it shows up as X/100. ie. 1 = 0.01, 2= 0.02, 30
= 0.3.....

I don't know where to look. I checked Option in Excel and control panel
in Windows without success.

I am thankfull for any ideas.

Siegi
 
R

raymondsum

Siegi,

You try to format the cell.

Format | Cells | Number | Number

Select your preference.

HTH

Raymond
 
S

Siegi

Hi Rymond,

to format the cell was the first thing I tryed. Can you format your
excel to do the same by using format function?

thank you
Siegi
 
N

Norman Harker

Hi Siegi!

Try:

Tools > Options > Edit Tab
Remove check from fixed decimal places

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top