| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to hide a formula and display something else?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to hide a formula and display something else?
Used a Named Formula;
http://www.ozgrid.com/Excel/named-formulas.htm -- Regards Dave Hawley www.ozgrid.com "ShaneChop" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to hide a formula and display something else?
Forget to mention, Custom Format the cell as: "PV"
-- Regards Dave Hawley www.ozgrid.com "ozgrid.com" wrote in message ... Used a Named Formula; http://www.ozgrid.com/Excel/named-formulas.htm -- Regards Dave Hawley www.ozgrid.com "ShaneChop" wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to hide a formula and display something else?
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" wrote in message ... 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to hide a formula and display something else?
As as I said afterwards, custom format the cell as "PV"
-- Regards Dave Hawley www.ozgrid.com "ShaneChop" wrote in message ... 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" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can i auto hide and display row or collum for zero value | Excel Discussion (Misc queries) | |||
| Want to display day and month in date and hide the formula | Excel Worksheet Functions | |||
| Hide Negative Numbers or Display as Zero | Excel Worksheet Functions | |||
| Hide/Don't Display Values | Excel Worksheet Functions | |||
| Is there a formula to hide/ display row based on cell value in Exc | Excel Worksheet Functions | |||
Hybrid Mode
