I had used your formula but that was not working fine so i put the value
before your formula
On Tue, May 7, 2013 at 7:17 PM, xlstime wrote:
> i think no need for use value function
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Tue, May 7, 2013 at 6:51 PM, priti verma wrote:
>
>>
i think no need for use value function
.
Enjoy
Team XLS
On Tue, May 7, 2013 at 6:51 PM, priti verma wrote:
> You can use this one also
> =VALUE(SUBSTITUTE(E2,",",""))
>
>
> On Tue, May 7, 2013 at 1:25 PM, danial mansoor wrote:
>
>> dear Experts:
>>
>> Kindly look at my
You can use this one also
=VALUE(SUBSTITUTE(E2,",",""))
On Tue, May 7, 2013 at 1:25 PM, danial mansoor wrote:
> dear Experts:
>
> Kindly look at my file,there are some numbers kindly convert this into
> numbers it is in text format.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And d
You can also you use formula
like =SUBSTITUTE(E2,",","")
On Tue, May 7, 2013 at 1:30 PM, Ahmed Honest wrote:
> Hi Danial :
>
> Press Ctrl + H and then
>
> in find what box keep comma , and in replace leave it empty and click
> Replace All it shall help...
>
>
>
>
>
>
>
> On Tue, May 7, 2013 a
Hi Danial :
Press Ctrl + H and then
in find what box keep comma , and in replace leave it empty and click
Replace All it shall help...
On Tue, May 7, 2013 at 10:55 AM, danial mansoor wrote:
> dear Experts:
>
> Kindly look at my file,there are some numbers kindly convert this into
> numb
dear Experts:
Kindly look at my file,there are some numbers kindly convert this into numbers
it is in text format.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this
