Windows Forum

Ask something
Discussion Locked

Excel Quirk?

0 helpful
3 replies

by haschg

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

In a large Excel spreadsheet, why does the value 4500 change to 2000? If I type 4,500 the value displays 4500. If I type 4500, the value displays 2000. I checked the formatting of the cell and it is correct.
Is there a bug in Excel that causes thisin large spreadsheets?

3 replies

by homer simpson instructor at large

i have seen this before and the only way we could get rid of it was to copy the correct parts of a spreadsheet over to a whole new workbook. I have seen this happen on small and large spreadsheets and it doesn't matter whether you remove cell formatting and reformat it, it still has the same problem. I don't know if excel is having a problem understanding the keystrokes from the keyboard, but the copy method worked for us.

by haschg

I'm a bit embarrassed to admit this but I never checked the auto correct. Some how the user created an entry replacing 4500 with 2000. I of course found this out after I posed the question. Thank you for your quick response.

This discussion is closed to new replies.