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

R

rjbind

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

David McRitchie

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".
 
Top