Enter 1 but appears as 0.01

J

Jane

I'm having a problem entering data (numbers) into cells. If I type in
number, say 1, it appears as 0.01. 100 appears as 1, 1000 as 10...an
so on. I've tried going to format then cells, then on the number ta
and clicking on general but that doesn't work.

Perhaps there's a simple solution but I can't seem to find it. Pleas
help
 
M

Max

Click Tools > Options > Edit tab
Uncheck "Fixed decimal" > OK
(It's probably checked for 2 d.p.)
 
R

Ron Rosenfeld

I'm having a problem entering data (numbers) into cells. If I type in a
number, say 1, it appears as 0.01. 100 appears as 1, 1000 as 10...and
so on. I've tried going to format then cells, then on the number tab
and clicking on general but that doesn't work.

Perhaps there's a simple solution but I can't seem to find it. Please
help.
Click to expand...

Tools/Options/Edit and DEselect "Fixed Decimal Places"


--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to display the value in different format? 8
Input numbers appearing incorrectly on spreadsheet 2
Numbers in work sheet not Formating right 1
Entering a number in any cell eg. 1 it changes to 0.01 why 3
integers entered are converted into decimal places e.g. 1 = 0.01 1
Numbered list problem 6
Enter 1 but appears as 0.01 3
numbers are being divided by 100 on leaving cell 4

Top