Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How can I include text (intended to be a comment) in a numeric
formula? Effectively, I would like to write something like the following: =A1 - A2 # this is the comment My goal is for the comment to be visible only when I look at the cell, but the cell retains its numeric quality. That is, in the example above, the cell evaluates to A1 minus A2, and other numeric formulas can refer to it straight-forwardly. I know that I can do "insert comment", but that is not what I want. I know I can do the following: =A1 - A2 + N("this is the comment") But I thought there is a more straight-forward way to do it. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date showing as numeric value in a text string formula | Excel Discussion (Misc queries) | |||
How do I include TEXT in the same cell with a FORMULA? | Excel Discussion (Misc queries) | |||
Formulas that include alpha and numeric characters | Excel Worksheet Functions | |||
vlookup to include text | Excel Worksheet Functions | |||
Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) |