Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display formulae instead of showing values in cells
Dear all,
I have got a worksheet with formulae in some cells, please tell how to display formulae in these cells instead of showing the values. Thanks Turks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display formulae instead of showing values in cells
You could write a ' in front of the = then excel treats the cell as text and
not as formula. if A1 = 1 and B1 = 2 and you enter following in c1 =A1+B1 -- 3 '=A1+B1 -- =A1+B1 hth Carlo "Kent" wrote: Dear all, I have got a worksheet with formulae in some cells, please tell how to display formulae in these cells instead of showing the values. Thanks Turks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display formulae instead of showing values in cells
Tools Options View Formulas
-- Regards - Peter "Kent" wrote: Dear all, I have got a worksheet with formulae in some cells, please tell how to display formulae in these cells instead of showing the values. Thanks Turks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display formulae instead of showing values in cells
I got it.
Thanks all. Turks "Peter" ... Tools Options View Formulas -- Regards - Peter "Kent" wrote: Dear all, I have got a worksheet with formulae in some cells, please tell how to display formulae in these cells instead of showing the values. Thanks Turks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I compare values of two cells and display the lowest. | Excel Worksheet Functions | |||
display formula instead of its values in some cells | Excel Worksheet Functions | |||
How do I print showing formulae written? | Excel Discussion (Misc queries) | |||
display zero values in selected cells | Excel Discussion (Misc queries) | |||
How to display the "values" included in a formula vs. the cells? | Excel Worksheet Functions |