Discussion Locked

Excel 2000 numbers issue

0 helpful

5 replies

by choy.waigiat Oct 10, 2005 last reply Oct 11, 2005

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

When I key in numbers like 100000 and press Enter, it will automatically change to 100. The zeros will be reduce.

advise anyone?

regards,

5 replies

Sounds to me rather like a formatting issue.

I would check some settings like number formatting and decimal/thousands seperator...

Is this happening to all worksheets or just one or two specific ones ?

Poster rated this answer.

Go to Tools - Options - Edit and deselect Fixed Decimal.

thanks. it work

This question was closed by the author

This discussion is closed to new replies.