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

2011-10-11 Thread somcpardeshi
al Message- From: waheedb...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 11 Oct 2011 07:44:40 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Prefix "0" before the number- Help Hi group, I have numeric data in column, each cell contains 5 to

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 numer

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

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

2011-10-11 Thread waheedbaba
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 characters. Exampl 1): 12345. Result: 0012345. Ex; 2) 384569 Result: 0384569 "0" should be