Making it text means it is something other than a number, but generally it has already screwed up the leading zeros by the time you have the opportunity to make it text.
You can set a special format if all the numbers are the same number of characters, but not for something like 0043 and 05467.
You have to set the cell as text rather than a number.
I wonder if you can format a cell with a custom number type to have leading zeros…
Making it text means it is something other than a number, but generally it has already screwed up the leading zeros by the time you have the opportunity to make it text.
You can set a special format if all the numbers are the same number of characters, but not for something like 0043 and 05467.
Thanks for the info.
I had the leading zero issue importing a CSV so I couldn’t set the cell type so I see your point.