Share via

Excel keeps reducing my number values

Anonymous
2015-12-06T06:42:30+00:00

I've just bought an updated version of excel. When I copied across an old spreadsheet and started to use it I notice when I entered a number the program would automatically reduce its' value e.g. 25000 become 250 and 2500 become 25. How do I fix this?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Vijay A. Verma 104.9K Reputation points Volunteer Moderator
2015-12-06T07:11:54+00:00

File > Options > Advanced > Uncheck the Red Zone

Was this answer helpful?

3 people found this answer helpful.
0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2015-12-15T20:20:38+00:00

    Thank you for your help Vijay!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments