| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I display a formula as text (instead of the value) in specific cells
Hi,
I would like to specify the values of the formulas in a few specific cells, rather than the resulting numerical values. I have seen approaches to display all the formulas in the worksheet, but that's not what I need. Is this possible? Thanks, Gabriel |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I display a formula as text (instead of the value) in specific
If you enter
=A1+B1 you will get the sum of A1 and B1 But if you enter '=A1+B1 you will see =A1+B1 preceding anything with ' treats the entry as a text... "G.R. Toro" wrote: Hi, I would like to specify the values of the formulas in a few specific cells, rather than the resulting numerical values. I have seen approaches to display all the formulas in the worksheet, but that's not what I need. Is this possible? Thanks, Gabriel |
|
#3
|
|||
|
|||
|
precede the formula in a cell with wildcard '
such as '=Sum(D1,E1) Chris ------ Convert your Excel spreadsheet into an online calculator. http://www.spreadsheetconverter.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
| Display contents of a specific cell even if a group of cells is mo | Excel Worksheet Functions | |||
| Display Text in Formula Bar for certain cells | Excel Worksheet Functions | |||
| Need to display a number when a specific text is entered | Excel Discussion (Misc queries) | |||
| display a range of editible cells based on specific in another cel | Excel Discussion (Misc queries) | |||
Linear Mode
