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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom format for credit card number 1
How to restrict zeros in a number from 16th digit onwards 5
Selecting data for report 2
Convert number to phone number 1
Macro - To Include Summing All Similar Entries 1
Convert number to ph # for mail merge (updated) 2
convert time in xxxx format to xx:xx 8
Custom Format on 16 Digit Number 5

Top