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

2011-10-11 Thread karan 1237
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

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.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

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 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

2011-10-11 Thread Manoj Kumar
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

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 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

2011-10-11 Thread waheedbaba

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

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 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

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-
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