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

- Apr 9, 2009 at 05:20 AM - Latest reply:  Hassan
- Dec 5, 2014 at 01:58 AM
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
See more 

6 replies

Best answer
Posts
191
Registration date
Sunday April 12, 2009
Last seen
February 16, 2010
- Apr 13, 2009 at 02:40 AM
11
Thank you
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))

Thank you, mubashir aziz 11

Something to say? Add comment

CCM has helped 1634 users this month

Hi Mubashir Aziz,
Thanks a lot for your help.I got the solutuion for my problem.
PUSHKAR NARAYAN - Aug 11, 2009 at 01:21 AM
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