Prefix 0 to all records in a column
Solved/Closed
Related:
- Prefix 0 to all records in a column
- Gacha nebula 1.1 .0 apk download - Download - Casual
- How to delete a column in word - Guide
- Need for speed most wanted 5-1-0 - Download - Racing
- Excel column number - Guide
- Summertimesaga-0-20-16-pc - Download - Adult games
1 response
mubashir aziz
Posts
190
Registration date
Sunday 12 April 2009
Status
Member
Last seen
16 February 2010
166
Modifié par Jeff le 2010/03/ 6 12:36 AM
Modifié par Jeff le 2010/03/ 6 12:36 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))
13 Apr 2009 à 04:48
Thanks a lot for your help.I got the solutuion for my problem.
11 Aug 2009 à 01:21
Thanks
Pushkar
5 Jul 2011 à 07:24
31 Aug 2013 à 03:59
5 Dec 2014 à 01:58
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