|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
Apr 16th, 2002, 04:10 PM
|
#1 |
|
New Member
Join Date: Mar 2002
Posts: 7
|
In Quatro pro you can add comments to a formula by typing a semicolon (
 after the formula. Is such a feature available in Excel other than by using the add comment and defining its display properties under Tools-options ? |
|
|
|
Apr 16th, 2002, 04:59 PM
|
#2 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Monterrey, Mexico
Posts: 1,433
|
No, there is no way.
__________________
Kind regards, Al Chara |
|
|
|
|
Apr 16th, 2002, 05:05 PM
|
#3 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,064
|
Eh
Chosts about me post has g g ggone. I did say not that i know commenst you can play with easy, and VBA them to really cool one. i hate the sqaure bos so i have little fluff blue sky and top white cloudes, ok its a fade but best i could do... select it right click on the boarder and edit profiles... nice..
__________________
Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you" |
|
|
|
|
Apr 16th, 2002, 05:06 PM
|
#4 |
|
New Member
Join Date: Mar 2002
Posts: 7
|
I feared as much, guess we'll have to wait forversion 2003
|
|
|
|
|
Apr 16th, 2002, 05:15 PM
|
#5 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,064
|
Hi
If its that painful attach a command button to trip the right click add comment etc... Assign to what ever is active cell. this i use so i avaoid boaring yellow boxes..
__________________
Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you" |
|
|
|
|
Apr 16th, 2002, 05:39 PM
|
#6 |
|
Board Regular
Join Date: Mar 2002
Posts: 64
|
If you want the comment to show, you could make it all text. That way you have the results of the formula and the comment in the same cell.
Example: =TEXT(A1+A2,"0") & " This is a comment" |
|
|
|
|
Apr 16th, 2002, 10:23 PM
|
#7 | |
|
MrExcel MVP
Join Date: Feb 2002
Location: Auckland, New Zealand
Posts: 4,209
|
Quote:
Use the N function eg. =IF(D15>C15,"nono",1234)+N("this is a comment - testing one two three 123")
__________________
Kind Regards, Ivan F Moala From the City of Sails 
|
|
|
|
|
|
Apr 17th, 2002, 10:21 AM
|
#8 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Monterrey, Mexico
Posts: 1,433
|
Come on guys, that's cheating.
|
|
|
|
|
Apr 17th, 2002, 11:46 AM
|
#9 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,064
|
cheatinh Nar thats the note formula we all know about.. good call guys.. i use this as a tag... works well wrap text helps so i
= xxxxxxx & CHAR(10) & & " " & N(whatever ....)
__________________
Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you" |
|
|
|
|
Apr 17th, 2002, 11:48 AM
|
#10 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,064
|
opps
fell i forgot the " " = xxxxxxx & CHAR(10) & & " " & N("whatever ....") I must get excel back ASPA and throw XP Win out... Did you know in WinXP you assign new printer via explorer! i shake me head.....
__________________
Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you" |
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
