Prefix 0 to all records in a column
Solved/Closed
Related:
- Prefix 0 to all records in a column
- //192.168.l.0 - Guide
- Xbox-2309-1001-3-0 - Download - Digital stores
- Whatsapp-desktop-2-2401-5-0.msixbundle - Download - Instant messaging
- +37 prefix - Guide
- How to send voice record in messenger - Guide
1 response
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
Apr 13, 2009 at 02:40 AM
Apr 13, 2009 at 02:40 AM
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))
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))
Apr 13, 2009 at 04:48 AM
Thanks a lot for your help.I got the solutuion for my problem.
Aug 11, 2009 at 01:21 AM
Thanks
Pushkar
Jul 5, 2011 at 07:24 AM
Aug 31, 2013 at 03:59 AM
Dec 5, 2014 at 01:58 AM
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