thank you
On Thu, Aug 7, 2014 at 10:00 AM, Vaibhav Joshi wrote:
> check this file.. press Alt + F8 to run macro
>
> Cheers!!
>
>
> On Wed, Aug 6, 2014 at 5:31 PM, my excel wrote:
>
>> is any solution from expert?
>>
>>
>> On Tue, Aug 5, 2014 at 12:52 PM, my excel wrote:
>>
>>> just copy p
check this file.. press Alt + F8 to run macro
Cheers!!
On Wed, Aug 6, 2014 at 5:31 PM, my excel wrote:
> is any solution from expert?
>
>
> On Tue, Aug 5, 2014 at 12:52 PM, my excel wrote:
>
>> just copy paste data to excel
>>
>> if i select A column data hit on button A column data conve
you can,
By all the means you can,
In all the ways you can,
In all the places 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
>To: excel-macros@googlegroups.com
>Sent: Wednesday,
is any solution from expert?
On Tue, Aug 5, 2014 at 12:52 PM, my excel 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 mobile
> no
>
>
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 Jo
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 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+1
Hi,
PFA...!!
Regards
Ashish
On 3 August 2014 21:36, my excel 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 9845098430
>
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
