Why does the screen show other than what I type into a cell?

C

CJ

I'm entering an amount into a cell, but the screen shows a number altogether
different from what I type.

I checked the format of the cell. I couldn't see anything wrong.
 
N

Niek Otten

Maybe a stupid question, but...
What did you type and what did you see? And how was the cell formatted?
 
U

ufo_pilot

Amount, hmm..., numbers?
Format>Cells>Numbers>Decimal places maybe
perhaps you typed in 0.899756 and are getting 1 because you have 0 or too
few decimal places formatted....????
 
S

Sloth

Can't say for sure without an example, but try these two solutions.

I. Under Tools->Options->Edit Tab
Make sure the "Fixed Decimal" is unchecked. This will change 260 to 2.6 and
2620 to 26.2.

II. Check the formatting. You might have a strange custom number format like
1234
this will make any number entered show up as 1234 instead of the number.
Change it to General or Number or something more appropriate.
 
Top