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