Number automatically divided by 100, why?

  • Thread starter Thread starter Don O'Hara
  • Start date Start date
D

Don O'Hara

When i key a random number into a cell (in MS Excel 2007)

the number will automatically divided by 100

for example:
if i key in 2000 and press ENTER, it will become 2 immediately

if i key in 50 and press ENTER, it will become 0.5 immediately


I've checked the data format. the format is "GENERAL".


Something wrong with the settings?
 
hi
you have "fixed decimal places" turned on.
in xl03, it's tools>options>edit tab>uncheck fixed decimal places.
in xl07, i'm not sure. office button>excel options>????
snoop around.
sorry i could not be more help. i know what the problem is, i just don't
have 07 yet.

regards
FSt1
 
perfect!, it works

FSt1 said:
hi
you have "fixed decimal places" turned on.
in xl03, it's tools>options>edit tab>uncheck fixed decimal places.
in xl07, i'm not sure. office button>excel options>????
snoop around.
sorry i could not be more help. i know what the problem is, i just don't
have 07 yet.

regards
FSt1
Click to expand...
 
When i key a random number into a cell (in MS Excel 2007)

the number will automatically divided by 100

for example:
if i key in 2000 and press ENTER, it will become 2 immediately

if i key in 50 and press ENTER, it will become 0.5 immediately

I've checked the data format. the format is "GENERAL".

Something wrong with the settings?
Click to expand...

Well, learn something new every day, however, I set "fised decimal
plasces" to 2 and when i put in 50 in it retuns 5000, not .5. Why is
that? Also, your first example of 2000 returing 2 is a 1,000 devisor
whereas the second example of 50 becoming .50 is a 100 devisor.
What's different?

ed
 
Hi,

Did you type the 2 into the box or click the spinner? It sounds like you
set it to -2 not 2.
 
Back
Top