| 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 | |||
Hybrid Mode
