Home

Why is my data formulating when I do not tell it to?

Madeline Clancy
New Contributor

I am organizing some account numbers in a spreadsheet under different headers which say what the account is for. I enter a number "200002244487" and when I go to work in the next cell, the data changes to

2.00002E+11

But the account number I entered remains in the fx toolbar window above...how do I remove whatever Excel is trying to formulate with my data? There are no signs telling it to complete an action, such as =,+, etc. Not sure why it's changing the data I enter, and it is happening with any sequence of numbers I use and in different cells. I have started a new workbook even and the problem remains. Help!

 

1 Reply

Hi

 

Above a certain size Excel converts numbers into scientific format.

If you don't have to do any calculations with the number then pre-format the cells as text. Otherwise change it to a number format with 0 decimal places.

 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies