is any solution from expert?
On Tue, Aug 5, 2014 at 12:52 PM, my excel myxlg...@gmail.com wrote:
just copy paste data to excel
if i select A column data hit on button A column data convert in to 10
digit no...
i want data as text also convert in to number it must be 10 digit
you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: my excel myxlg...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wednesday, August 6, 2014 8:01 AM
Subject: Re: $$Excel-Macros$$ make 10 digit
check this file.. press Alt + F8 to run macro
Cheers!!
On Wed, Aug 6, 2014 at 5:31 PM, my excel myxlg...@gmail.com wrote:
is any solution from expert?
On Tue, Aug 5, 2014 at 12:52 PM, my excel myxlg...@gmail.com wrote:
just copy paste data to excel
if i select A column data hit on
thank you
On Thu, Aug 7, 2014 at 10:00 AM, Vaibhav Joshi v...@vabs.in wrote:
check this file.. press Alt + F8 to run macro
Cheers!!
On Wed, Aug 6, 2014 at 5:31 PM, my excel myxlg...@gmail.com wrote:
is any solution from expert?
On Tue, Aug 5, 2014 at 12:52 PM, my excel
just copy paste data to excel
if i select A column data hit on button A column data convert in to 10
digit no...
i want data as text also convert in to number it must be 10 digit mobile
no
remove 91
remove 0
using = right 10
want in macro button
On Mon, Aug 4, 2014 at 2:03 PM, Vaibhav
hi
you can do it without macro by changing cell format to number format.
Cheers!!
On Sun, Aug 3, 2014 at 9:36 PM, my excel myxlg...@gmail.com wrote:
Sir,
i have a excel file its contains customer mobile no
ex:
Jan Feb Mar …. ….. etc 919845098450 09888021555 9.19293E+11
Sir,
i have a excel file its contains customer mobile no
ex:
Jan Feb Mar …. ….. etc 919845098450 09888021555 9.19293E+11 919899989696
9.19845E+11 9.19845E+11 09595959595 +919449449460 9845098430 9845098430
94949494949
[image: Inline image 1]
Q: how to convert to 10 digit mobile no ?
i
Hi,
PFA...!!
Regards
Ashish
On 3 August 2014 21:36, my excel myxlg...@gmail.com wrote:
Sir,
i have a excel file its contains customer mobile no
ex:
Jan Feb Mar . etc 919845098450 09888021555 9.19293E+11
919899989696 9.19845E+11 9.19845E+11 09595959595 +919449449460