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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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