Forum Discussion
Excel custom format id number
I want to create a form where persons have to enter their id numbers. It must look like this: 000000 0000 000 When I do this Excel changes it to 0 000 000 000 000 as if it is thousands. It works ...
It did not work. Eventually saw that I have to change it to
000000\ 0000\ 000
This works.
000000\ 0000\ 000
This works.
Space and some other characters like colon, caret, etc are displayed in custom number format natively. Backslah is required for other characters like percent. Perhaps you didn't enter format manually but copy / paste from web, when non-printable characters may appear which require backslah.