entering 0 to a range of data in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do i Prefix 0 to all the data in a perticular data.
Eg. I have different No. like 1234, 3432, 3453 etc in a column and want to see that it shows up as 01234,03432,03453
 
If it is just for display just use a custom format like 00000,
if you need 5 characters in the cell you can use a help column and then use

=TEXT(A2,"00000")

copy down, edit>paste special as values in place, delete original column

--

Regards,

Peo Sjoblom


Manoj Nair said:
How do i Prefix 0 to all the data in a perticular data.
Eg. I have different No. like 1234, 3432, 3453 etc in a column and want to
Click to expand...
see that it shows up as 01234,03432,03453
 
Back
Top