ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Numbers (https://www.excelbanter.com/excel-worksheet-functions/159362-numbers.html)

Hector

Numbers
 
I'm trying to enter a 17 digit number on a cell and somehow it always changes
the last 2 numbers into a ceros. I have tried to format the cell to number
and general and it coutinues to do so. but only when I enter a large number
ei: 43343302223640001 then the one will auto change to cero.

help please. frustrated.

Peo Sjoblom

Numbers
 
Excel has 15 numerical digit precision so you can either preformat the cell
as text or precede the entry with an apostrophe '


--

Regards,

Peo Sjoblom





"Hector" wrote in message
...
I'm trying to enter a 17 digit number on a cell and somehow it always
changes
the last 2 numbers into a ceros. I have tried to format the cell to
number
and general and it coutinues to do so. but only when I enter a large
number
ei: 43343302223640001 then the one will auto change to cero.

help please. frustrated.





All times are GMT +1. The time now is 08:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com