Number automatically divided by 100, why?
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?
|