Forum Discussion
How to convert number to text
if I have value in numbers 1, 2,3,4,100,1005 and want to convert in text like 0001,0002 and with only zero in 100 e.g 0100. could you please help me to resolve the above. Regards,
If you want to display numbers that way, apply the custom number format 0000 to the cells with the numbers.
If you want to return the formatted number as text: let's say the numbers are in A2:A100.
In B2, enter the formula =TEXT(A2, "0000")
Fill down to B100.