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.
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.