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.

5 total posts (Page 1 of 1)  
| 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

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums