Jun 30 2021 05:32 AM
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 on our on pc, but not on my laptop.
I live in South Africa, we use decimal comma, and my laptop knows this. Not sure if this is the problem.
Jun 30 2021 05:41 AM
@Rika2608 Irrespective of your local settings you can set a custom format to the cells that hold the ID numbers. The custom format would be exactly as you specifies it, 000000 0000 000
Jun 30 2021 05:59 AM
Jun 30 2021 01:29 PM
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.