15 digets

  • Thread starter Thread starter lostsoul62
  • Start date Start date
L

lostsoul62

I'm trying to put in a 15 diget number and it keeps turning the last number
to zero. I'm using excel 2007. Under format cell, I use numbers
 
Excel has a limit of 15 digits. If your are working with really big
umbers - meaning you want to do arithmetic operations on these numbers -
then Excel is not for you. But if they are nor true numbers (ie things like
credit card numbers) then they can be entered as text by
1) first formatting the cell as Text
OT 2) typing a single apostrophe before the 'number' - the apostrophe will
not display in the cell, nor will it appear in a print out.
best wishes
 
lostsoul62 said:
I'm trying to put in a 15 diget number and it keeps
turning the last number to zero. I'm using excel
2007. Under format cell, I use numbers
Click to expand...

Examples?
 
I would suggest that you count the digits again.
A quote from MS Article
--------------------------------------------------------------------------------------
Microsoft Excel retains 15 significant digits. To display all 15 digits, you
must use a number format (custom or built-in) other than General. The General
number format displays up to 11 numeric characters, with the decimal point
counting as a numeric character. Therefore, if the number contains a decimal
point, Excel can display up to 10 significant digits, but if the number does
not contain a decimal point, Excel can display up to 11 significant digits
Adding more numbers to the left of the decimal point causes the number to
appear in exponential notation.
 
A limitation of your computer is that it holds numbers accurately to a
maximum of 15 digits. If you want more than 15 digits you can change the cell
format to Text and re-enter the number or add a ' at the beginning of the
number to denote it as text.
 
Back
Top