i have many syntific value 20 digit how i know orignal value
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
syntific
0
Answers
0
Hi and welcome to the Forum
Not sure I understand your question but suggest you see Don's tutorial here: Convert Scientific Notation to Numbers in Excel
Excel works with 15 digits of precision., i.e. after 15 digits typed in a cell, it will change any further digits into zeroes. You can input more digits if you format the cell as text (or put ' before your 20 or more digit number) but If Excel already rounded your number to its 15 digits of precision, I don't believe you can restore the "rounded" digits.
Discussion
p.s please delete your earlier question and your Answer above (Answers should be solutions to the question posed)
John_Ru (rep: 6142) Mar 8, '22 at 6:53 am
@Don- Any idea why the Forum page shows 0 Answers for this (although there's an answer above)? If it due to the deletion of the question with the duplicate title?
John_Ru (rep: 6142) Mar 8, '22 at 11:36 am
I was just wondering what happened with that as I'm the one who removed the other 'answer' - I don't recall it being an issue before. Also, did you get my email the other day? My internet is Very bad now and sometimes Outlook has not been sending everything. Bad internet might also explain the post count not updating if the deletion page never fully loaded everything.
don (rep: 1989) Mar 8, '22 at 4:25 pm
Thanks Don. That's odd but not to worry.
I got your email of March 01 and omitted to reply, sorry. Will do so shortly.
I got your email of March 01 and omitted to reply, sorry. Will do so shortly.
John_Ru (rep: 6142) Mar 8, '22 at 4:44 pm