1 only define for format text you can put any numerical value
On Mon, Aug 1, 2011 at 7:51 PM, Chandra Shekar wrote:
> Hi,
>
> =TEXT(C3;1) - Here whats 1 stands for please let me know. Thanks
>
> On Mon, Aug 1, 2011 at 2:40 PM, XLS S wrote:
>
>> Hey,
>>
>>
>> In any blank cell enter any value li
Hi,
=TEXT(C3;1) - Here whats 1 stands for please let me know. Thanks
On Mon, Aug 1, 2011 at 2:40 PM, XLS S wrote:
> Hey,
>
>
> In any blank cell enter any value like 1,2,3,name..then copy the
> cell...and hold ctrl buttonthen.select
> hyperlink (with
Hey,
In any blank cell enter any value like 1,2,3,name..then copy the
cell...and hold ctrl buttonthen.select
hyperlink (with hold ctrl button) cellsnow..just right
click.paste special select Multiply (in operation)
See the attached List
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Neelakanta AB
Sent: Monday, August 01, 2011 3:33 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Remove HyperLink without Macro
Hi
Not able to work on the
Hi
Not able to work on the same format suggested.
Share little more details for this it will be very helpful.
Thanks!
On Mon, Aug 1, 2011 at 3:27 PM, Chandra Shekar wrote:
> Hi,
>
> I tried but I could not able to get this. I am stuck up with point 2 i.e.
> Select the cell and press *Ctrl+C*.
Hi,
I tried but I could not able to get this. I am stuck up with point 2 i.e.
Select the cell and press *Ctrl+C*.
Please can u explain briefly regarding this. Thanks!
On Sun, Jul 31, 2011 at 2:37 PM, GoldenLance wrote:
> Nice one XLS S
>
> On Jul 31, 10:41 am, XLS S wrote:
> > Dear All,
> >
>
Nice one XLS S
On Jul 31, 10:41 am, XLS S wrote:
> Dear All,
>
> Try this
>
> 1. In a blank cell, enter the number 1.
> 2. Select the cell and press *Ctrl+C*.
> 3. Hold down the *Ctrl* key as you click each hyperlink you want to
> remove.
> 4. Right Click and Choose Paste Special f
