Click here to Skip to main content
15,563,054 members
Please Sign up or sign in to vote.
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
Comments
Maciej Los 19-Mar-22 6:38am    
What method do you use to convert text into numbers? Do you use menu or vba code?

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.
 
Share this answer
 
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.
 
Share this answer
 
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
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900