Prefix 0 to all records in a column [Solved/Closed]

Report
-
 Hassan -
Hello,
I want to prefix 0(zero) to all records in a particular column of an excel sheet.Please let me know how to do it.
Thanks for your time,
Manohar

7 replies

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
210
If the data in numeric then select the columns and go in

Format > Cell > Number > Custom > write 0#,##.00

your all number will have 0 prefix ....

if in excel, if you want it as text:
=if(len(a1)=1,"0"&value(a1),value(a1))
11
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 5808 users have said thank you to us this month

Hi Mubashir Aziz,
Thanks a lot for your help.I got the solutuion for my problem.

i did not find solution as I do as suggested but problem not solved

Thanks
Pushkar
Thanks for sharing it. It helped a lot
Thanks for sharing it
This will not add 0 to the number, it will just change the way of displaying the number. Meaning if you copy it to another excel and change the format, the number will show without the leading 0.

A better solution is to
- insert a col before (say A) and col after (say C) the col containing your number (consider B).
- in the col A, type 0 or 00 ... and make sure cell format is text.
-in cell C1 insert formula: =CONCATENATE(A1,B1)

now select the col C and copy paste data as Values to break the formula.
You can now delete col A & Col B.

Cheers
Hassan