I have an ID that is used in my spreadsheet with the following custom format:
##-#####-###
End result:
01-01234-001
14-01234-002
I want the user to enter the numbers and then this format will enter the dashes. That works fine, but something else doesn't.
When the ID starts with a single digit, I want the format to enter the leading zero.
Yes - 01-12345-001
No - 1-12345-001
How can this be done?
Thank you in advance!
Bookmarks