entering 0 to a range of data in a column

M

Manoj Nair

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
 
P

Peo Sjoblom

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
 
D

Dave Peterson

Or maybe just format those cells (whole column???) with a custom format of:

00000
 
Top