Add Zeros In Front Of Numbers

[temp6626]

Hi,

I have the following data as text in my file:

5
13
108
5525
97875

I would like the following results:
00005
00013
00108
05525
97875

So in other words, I would like to make the text 5 characters and when needed, insert zeros in front of the numbers. Is there any way to convert/insert zeros in front of the numbers to make them look like the results above? Appreciate your help.

Thanks,
Kishore

[shg]

Welcome to Oz, temp

Format > cells > number > custom > 00000

[RichardSchollar]

If you already have the data entered as text, then you may need an intermediate formula to convert to the required format:

=TEXT(A1+0,"00000")

Assuming you have the A column formatted as text, you can then copy and paste values from the formulas back into your original column.

Richard

[temp6626]

Thanks for the prompt reply guys. This is awesome to get such quick responses. I realized that I should not have these cells formatted as text. Otherwise, it won't work. Thank you so much Shg for your solution. You have made my day today. This will help me out alot in the future.

Thank you guys. I'm coming back to this site all the time now.

Kishore