User-Defined Cell Format: Letters and Numbers
Posted: Sat Jan 12, 2019 7:55 pm
I want to create a User-Defined Cell Format (Format Cells > Numbers) that will allow a mixture of letters and numbers to display with automatically embedded hyphens.
For example: I want to be able to enter the following "841501F001234" and have it display as "8415-01-F00-1234".
I have tried the custom cell format of "####-##-###-####" and it works great with data of numbers only (such as "8415010001234'), but when the data contains a letter, it fails.
Is there a character other than "#" that I can use in the custom format string that will accept both numbers and letters?
For example: I want to be able to enter the following "841501F001234" and have it display as "8415-01-F00-1234".
I have tried the custom cell format of "####-##-###-####" and it works great with data of numbers only (such as "8415010001234'), but when the data contains a letter, it fails.
Is there a character other than "#" that I can use in the custom format string that will accept both numbers and letters?