15,563,054 members
1.00/5 (1 vote)
See more:
I have data in my excel file
Cell data 28009105740071330
And error showing Number stored as text, when i try click convert to number my cell data value automatically change in new value 2800910574001300

What I have tried:

Why my cell data change in different numbers and how i stop this change
Posted
Updated 19-Mar-22 1:51am
Maciej Los 19-Mar-22 6:38am
What method do you use to convert text into numbers? Do you use menu or vba code?

## Solution 1

See here: Understanding Floating Point Precision, aka “Why does Excel Give Me Seemingly Wrong Answers?” - Microsoft 365 Blog[^]
But this is not an Excel support site: we are a software development site and we did not produce Excel! There are numerous Excel forums both MS and other - Google will find you many if you ask (just don't give them any credit card details). Please use them in future.

## Solution 2

Quote:
And error showing Number stored as text, when i try click convert to number my cell data value automatically change in new value 2800910574001300

Yes, Excel have limits with numbers. The floating point format have a limit in matters of number of significant digits in a number.
Quote:
how i stop this change

Use another tool with those values.
We need some context to advice a solution.

## Solution 3

Assuming that you store text-number in column "A"... do the following trick: select column "B" and format cells as scientific, then use formula:
```RowNo   A                    B
1       28009105740071330    =A1```

Then, fill down the formula.
Note: do not forget to increase width of column "B" before you start adding formula!
Result:
```A                   B
28009105740071330	28009105740071330```