Software

General discussion

Locked

Excel 2000 numbers issue

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

advise anyone?

regards,

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by Breydel In reply to Excel 2000 numbers issue

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 ?

Collapse -

by choy.waigiat In reply to

Poster rated this answer.

Collapse -

by Toivo Talikka In reply to Excel 2000 numbers issue

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

Collapse -

by choy.waigiat In reply to

thanks. it work

Collapse -

by choy.waigiat In reply to Excel 2000 numbers issue

This question was closed by the author

Related Discussions

Related Forums