Re: $$Excel-Macros$$ Prefix 0 before the number- Help
Hey Waheeb, Pls find enclosed. Kaяan http://www.facebook.com/singhkarann http://twitter.com/#%21/karan1237 https://plus.google.com/43524614789164919/posts http://www.myspace.com/singhkaran http://www.linkedin.com/in/singhkarann http://karanxel.blogspot.com/ http://karanxel.wordpress.com/ On Tue, Oct 11, 2011 at 1:14 PM, waheedb...@gmail.com 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 characters. Exampl 1): 12345. Result: 0012345. Ex; 2) 384569 Result: 0384569 0 should be prefixed here... Thanks in advance, Regards, waheed -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Query.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Prefix 0 before the number- Help
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.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Tue, Oct 11, 2011 at 1:14 PM, waheedb...@gmail.com 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 characters. Exampl 1): 12345. Result: 0012345. Ex; 2) 384569 Result: 0384569 0 should be prefixed here... Thanks in advance, Regards, waheed -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Prefix 0 before the number- Help
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 karan1...@gmail.com wrote: Hey Waheeb, Pls find enclosed. Kaяan http://www.facebook.com/singhkarann http://twitter.com/#%21/karan1237 https://plus.google.com/43524614789164919/posts http://www.myspace.com/singhkaran http://www.linkedin.com/in/singhkarann http://karanxel.blogspot.com/ http://karanxel.wordpress.com/ On Tue, Oct 11, 2011 at 1:14 PM, waheedb...@gmail.com 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 characters. Exampl 1): 12345. Result: 0012345. Ex; 2) 384569 Result: 0384569 0 should be prefixed here... Thanks in advance, Regards, waheed -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Query.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Prefix 0 before the number- Help
See if this helps... Best, Manoj Kumar On Tue, Oct 11, 2011 at 1:14 PM, waheedb...@gmail.com 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 characters. Exampl 1): 12345. Result: 0012345. Ex; 2) 384569 Result: 0384569 0 should be prefixed here... Thanks in advance, Regards, waheed -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel GG_Append.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Prefix 0 before the number- Help
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 noorain.ans...@gmail.comwrote: 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.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Tue, Oct 11, 2011 at 1:14 PM, waheedb...@gmail.com 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 characters. Exampl 1): 12345. Result: 0012345. Ex; 2) 384569 Result: 0384569 0 should be prefixed here... Thanks in advance, Regards, waheed -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: Re: $$Excel-Macros$$ Prefix 0 before the number- Help
Thnx everyone for u help. On , Swapnil Palande palande.swapni...@gmail.com 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 at 2:09 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: 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.blogspot.com/ http://noorain-ansari.blogspot.com/ On Tue, Oct 11, 2011 at 1:14 PM, waheedb...@gmail.com 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 characters. Exampl 1): 12345. Result: 0012345. Ex; 2) 384569 Result: 0384569 0 should be prefixed here... Thanks in advance, Regards, waheed -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Prefix 0 before the number- Help
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 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 prefixed here... Thanks in advance, Regards, waheed -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Prefix 0 before the number- Help
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- From: waheedb...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 11 Oct 2011 07:44:40 To: excel-macros@googlegroups.com 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 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 prefixed here... Thanks in advance, Regards, waheed -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel