15 digets
 

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

15 digets
 

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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"lostsoul62" wrote in message
...
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

15 digets
 

"lostsoul62" wrote:
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

Examples?

15 digets
 

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.
--
HTH...

Jim Thomlinson


"lostsoul62" wrote:

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