Prev: Sorting Project that Requires Math Skills
Next: Adding fractions and displaying as Percentages
From: ShaneChop on 28 Apr 2010 23:35
I have a cell with a PV function and I want to know how to leave that
function active in that same cell but I want to only have the words "PV" be
visible in cell. How can I do that?
From: ozgrid.com on 28 Apr 2010 23:40
Used a Named Formula;
http://www.ozgrid.com/Excel/named-formulas.htm


--
Regards
Dave Hawley
www.ozgrid.com
"ShaneChop" <ShaneChop(a)discussions.microsoft.com> wrote in message
news:4C3CCC6E-BC4C-4D41-8D2A-8BF69FDB0806(a)microsoft.com...
>I have a cell with a PV function and I want to know how to leave that
> function active in that same cell but I want to only have the words "PV"
> be
> visible in cell. How can I do that?

From: ozgrid.com on 28 Apr 2010 23:53
Forget to mention, Custom Format the cell as: "PV"


--
Regards
Dave Hawley
www.ozgrid.com
"ozgrid.com" <dave(a)ozgrid.com> wrote in message
news:FB7A6E04-42DB-4941-B368-09B8565F11FD(a)microsoft.com...
> Used a Named Formula;
> http://www.ozgrid.com/Excel/named-formulas.htm
>
>
> --
> Regards
> Dave Hawley
> www.ozgrid.com
> "ShaneChop" <ShaneChop(a)discussions.microsoft.com> wrote in message
> news:4C3CCC6E-BC4C-4D41-8D2A-8BF69FDB0806(a)microsoft.com...
>>I have a cell with a PV function and I want to know how to leave that
>> function active in that same cell but I want to only have the words "PV"
>> be
>> visible in cell. How can I do that?
>

From: ShaneChop on 29 Apr 2010 00:13
I have that same formula in other cells but i only want that particular cell
to display something different. Do you know how?

"ozgrid.com" wrote:

> Used a Named Formula;
> http://www.ozgrid.com/Excel/named-formulas.htm
>
>
> --
> Regards
> Dave Hawley
> www.ozgrid.com
> "ShaneChop" <ShaneChop(a)discussions.microsoft.com> wrote in message
> news:4C3CCC6E-BC4C-4D41-8D2A-8BF69FDB0806(a)microsoft.com...
> >I have a cell with a PV function and I want to know how to leave that
> > function active in that same cell but I want to only have the words "PV"
> > be
> > visible in cell. How can I do that?
>
From: ozgrid.com on 29 Apr 2010 00:15
As as I said afterwards, custom format the cell as "PV"


--
Regards
Dave Hawley
www.ozgrid.com
"ShaneChop" <ShaneChop(a)discussions.microsoft.com> wrote in message
news:D8820F06-F8AA-4111-A8B4-2DD1EFCDA5E7(a)microsoft.com...
>I have that same formula in other cells but i only want that particular
>cell
> to display something different. Do you know how?
>
> "ozgrid.com" wrote:
>
>> Used a Named Formula;
>> http://www.ozgrid.com/Excel/named-formulas.htm
>>
>>
>> --
>> Regards
>> Dave Hawley
>> www.ozgrid.com
>> "ShaneChop" <ShaneChop(a)discussions.microsoft.com> wrote in message
>> news:4C3CCC6E-BC4C-4D41-8D2A-8BF69FDB0806(a)microsoft.com...
>> >I have a cell with a PV function and I want to know how to leave that
>> > function active in that same cell but I want to only have the words
>> > "PV"
>> > be
>> > visible in cell. How can I do that?
>>

 | 
Pages: 1
Prev: Sorting Project that Requires Math Skills
Next: Adding fractions and displaying as Percentages