Format a number (i.e. 1111111111111111) to show XXXX-XXXX-1111-11
 

How would I format a cell to show a 16 digit number (i.e. 1234567891234567)
to look like XXXX-XXXX-9123-4567 after I type in the number.

Thanks for your help in advance.

Format a number (i.e. 1111111111111111) to show XXXX-XXXX-1111-11
 

You will have to treat it as text, and not a number.
Excel only allows 15 significant digits.

Format the column a text or enter a single quote
before the "number", which is in fact an identity
"number".

--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"rjbind" wrote in message ...
How would I format a cell to show a 16 digit number (i.e. 1234567891234567)
to look like XXXX-XXXX-9123-4567 after I type in the number.

Thanks for your help in advance.