Question abour data convertion In Excel

  • Thread starter Thread starter LCR
  • Start date Start date
L

LCR

I have a problem with data convertion in excel. I have a sentence SQL that
return me a value, when I paste this value into excel, it show me a distinct
value. How can I do for fix this?

I show you an example (with this datas you can do the same test - Copy this
number and paste into excel
Le muestro un ejemplo: (con estos datos usted puede hacer la misma prueba -

Value (original number): 115250889625058557356100
paste into Excel: 1.15251E+23
Copied value convert to numeric value

115,250,889,625,058,000,000,000.00

Lucky!!!

Have a Nice day...
 
Excel operates with 15 digit precision. The 16th and after will be rounded and return
zeros. If you need extreme numeric precision the Excel is not the tool to use for your
task.
 
Back
Top