ExcelBanter - 7,07046E+16 appears when i should be 70704610008791736

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

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

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

Birger

7,07046E+16 appears when i should be 70704610008791736

Lady Layla

Excel only holds 15 places. Is this a true number that needs to be calculated
or is it say a part number? If you format the cells before hand as text or if
you preceed the number with ' then all the digits will appear

"Birger" wrote in message
...
:

All times are GMT +1. The time now is 05:08 PM.