MrExcel Publishing
Your One Stop for Excel Tips & Solutions

16 numbers in one cell


Posted by Eric on October 25, 2001 10:00 AM

How do you get excel to let you put more than 15 numbers in 1 cell. Trying to format a cell to take a credit card number in this form; 0000-0000-0000-0000.


Posted by Tom Urtis on October 25, 2001 10:04 AM

Select the cell(s) you want to format, then click on Format > Cells, and select the number tab. In the Category box highlight "Custom". In the Type box to the right, enter 0000"-"0000"-"0000"-"0000

Tom Urtis

Posted by Tom Morales on October 25, 2001 10:06 AM

Eric
Select "Format/Cell/Number/Custom". In the "Type" field, put in

0000-0000-0000-0000

And you're done.
Tom

Posted by Eric on October 25, 2001 10:11 AM

It still only allows me to enter 15 numbers, for instance if I put in 1111111111111111 it shows up in the cell like this 1111-1111-1111-1110.

Posted by Eric on October 25, 2001 10:13 AM

That doesn't work, what ever the last number is it always shows up 0.

Eric

Posted by Lars on October 25, 2001 11:00 AM

Excel 2002 version you will not have this problem


Posted by Dan on October 25, 2001 11:21 AM

Excel has a limitation of 15 significant digits. The best workaround is to split the digits in to multiple (i.e 4) cells. It still only allows me to enter 15 numbers, for instance if I put in 1111111111111111 it shows up in the cell like this 1111-1111-1111-1110.

Posted by Dan on October 25, 2001 11:26 AM

Lars -

According to Microsoft's site, the 15 significant limitation applies also to Excel 2002. Can you verify differently?

Posted by Mark W. on October 25, 2001 11:45 AM

Don't enter it as a number... you're not gonna use it in an arithmetic expression...

Format your cell as "Text" and then enter your
credit card number with the hypens (or spaces). How do you get excel to let you put more than 15 numbers in 1 cell. Trying to format a cell to take a credit card number in this form; 0000-0000-0000-0000.

Posted by Mark W. on October 25, 2001 11:49 AM

A hypen is a valid format character... the quotes aren't necessary (nt)

Posted by Mark W. on October 25, 2001 11:54 AM

Actually...

...there's no need to format the cell at all...
just enter your credit card number with hypens
(or spaces). Format your cell as "Text" and then enter your

Posted by Barrie Davidson on October 25, 2001 12:38 PM

Common sense....trust you to come up with the answer! (nt)

Posted by Mark W. on October 25, 2001 12:41 PM

You're very generous and kind : ) (nt)

Posted by Lars on October 25, 2001 2:42 PM

Re: Lars -

MY BAD IT ONLY TAKES 15 AS WELL ANYHTING AFTER THAT COVERTS TO 0 According to Microsoft's site, the 15 significant limitation applies also to Excel 2002. Can you verify differently?