LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 85
Default How to include text (comment) in numeric formula?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date showing as numeric value in a text string formula dj479794 Excel Discussion (Misc queries) 4 July 2nd 07 11:59 PM
How do I include TEXT in the same cell with a FORMULA? NJCHAZ Excel Discussion (Misc queries) 2 June 21st 07 05:39 PM
Formulas that include alpha and numeric characters Doktor1 at Mile High Excel Worksheet Functions 2 December 23rd 06 07:36 PM
vlookup to include text Louise Excel Worksheet Functions 7 October 9th 06 05:15 PM
Numeric in Text to convert back to the form of Numeric for VLookup Purposes achilles Excel Discussion (Misc queries) 4 February 6th 06 07:05 AM


All times are GMT +1. The time now is 09:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"