Comments

[Peter99]

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 ?

 

[Al Chara]

No, there is no way.

 

[Jack in the UK]

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..

 

[Peter99]

I feared as much, guess we'll have to wait forversion 2003

 

[Jack in the UK]

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..

 

[Fryer Tuck]

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"

 

[Ivan F Moala]

On 2002-04-16 15:10, Peter99 wrote:
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 ?

yes you can sought of.

Use the N function eg.

=IF(D15>C15,"nono",1234)+N("this is a comment - testing one two three 123")

 

[Al Chara]

Come on guys, that's cheating.

 

[Jack in the UK]

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 ....)

 

[Jack in the UK]

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.....