ExcelBanter - Appears like 7,07046E+16, should be 70704610008791736

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Appears like 7,07046E+16, should be 70704610008791736 (https://www.excelbanter.com/excel-discussion-misc-queries/4362-appears-like-7-07046e-16-should-70704610008791736-a.html)

wallis

Appears like 7,07046E+16, should be 70704610008791736

Jason Morin

You're limited to 15 digit precision in XL. If it's not a
number, preformat the cell as text.

HTH
Jason
Atlanta, GA

-----Original Message-----

.

All times are GMT +1. The time now is 03:04 PM.