Simply CUSTOM format the cells as 0000000

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

Reply via email to