![]() |
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. |
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