Re: $$Excel-Macros$$ Prefix "0" before the number- Help

2011-10-11 Thread somcpardeshi
Hi Try this =text(A2,"000") This will convert in text with format as per your req. If you want same value in number then change the format with to custom 000 Thanks and regards, Somnath C Pardeshi +91 829 111 9311 Sent from my BlackBerry® Smartphone on Loop Mobile. -Original Message-

Re: $$Excel-Macros$$ Prefix "0" before the number- Help

2011-10-11 Thread dguillett1
Simply CUSTOM format the cells as 000 Don Guillett SalesAid Software dguille...@gmail.com From: waheedb...@gmail.com Sent: Tuesday, October 11, 2011 2:44 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Prefix "0" before the number- Help Hi group, I have numeric data in col

Re: Re: $$Excel-Macros$$ Prefix "0" before the number- Help

2011-10-11 Thread waheedbaba
Thnx everyone for u help. On , Swapnil Palande wrote: Hi, You can use Text function. =Text(A1, "000") this formula will convert number into text But if you want to keep it number only then use custom format as per suggested by Noorain On Tue, Oct 11, 2011

Re: $$Excel-Macros$$ Prefix "0" before the number- Help

2011-10-11 Thread Swapnil Palande
Hi, You can use Text function. =Text(A1, "000") this formula will convert number into text But if you want to keep it number only then use custom format as per suggested by Noorain On Tue, Oct 11, 2011 at 2:09 PM, NOORAIN ANSARI wrote: > Dear Waheed, > > Please use below formula > > *=REPT

Re: $$Excel-Macros$$ Prefix "0" before the number- Help

2011-10-11 Thread Manoj Kumar
See if this helps... Best, Manoj Kumar On Tue, Oct 11, 2011 at 1:14 PM, wrote: > Hi group, > > I have numeric data in column, each cell contains 5 to 6 numeric values but > are less 7 characters. > For example: 12345, > 385469. > > What I want is, what ever is the count it should round upto 7

Re: $$Excel-Macros$$ Prefix "0" before the number- Help

2011-10-11 Thread Swapnil Palande
hi, Use Text function to prefix 0 before number ex: =TEXT(A1, "000") Pls find attached excel. Regards, Swapnil. On Tue, Oct 11, 2011 at 1:48 PM, karan 1237 wrote: > Hey Waheeb, > > Pls find enclosed. > > > Kaяan > >

Re: $$Excel-Macros$$ Prefix "0" before the number- Help

2011-10-11 Thread NOORAIN ANSARI
Dear Waheed, Please use below formula *=REPT(0,(7-LEN(A1)))&A1* ** *you can change 7 as per your requirement.* ** *Step-2.* ** *you can also use custom format.* ** *Select cell press ctrl+1 and type 000 in Type Text Box.* ** -- Thanks & regards, Noorain Ansari *http://excelmacroworld.b

Re: $$Excel-Macros$$ Prefix "0" before the number- Help

2011-10-11 Thread karan 1237
Hey Waheeb, Pls find enclosed. Kaяan