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 toolsoptionsedit tabuncheck fixed decimal places.
in xl07, i'm not sure. office buttonexcel 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

"Don O'Hara" wrote:

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?

perfect!, it works

"FSt1" wrote:

hi
you have "fixed decimal places" turned on.
in xl03, it's toolsoptionsedit tabuncheck fixed decimal places.
in xl07, i'm not sure. office buttonexcel 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

"Don O'Hara" wrote:

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?

On Feb 15, 9:51*pm, Don O'Hara <Don
wrote:
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?

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"ed" wrote:

On Feb 15, 9:51 pm, Don O'Hara <Don
wrote:
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?

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