G
Guest
I want to convert numbers in excel to a format with a set amount of digits.
For example, 1 becomes 001, 12 becomes 012 etc.
I have created a special format using 000. This works until I want to work
with these numbers, for example by using CONCATENATE. So if I have 01 and
012 and want it to be 01012, it ends up as 112.
Any suggestion on how to preserve formatting?
For example, 1 becomes 001, 12 becomes 012 etc.
I have created a special format using 000. This works until I want to work
with these numbers, for example by using CONCATENATE. So if I have 01 and
012 and want it to be 01012, it ends up as 112.
Any suggestion on how to preserve formatting?