LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Mantvydas
 
Posts: n/a
Default Comments for functions

Sometimes in worksheets the formulas can get out of hand, and when you open a
file a while after you last touched it, you can no longer understand some
formulas you have in your worksheets.

Can you please include syntax for cell function parser, so that it is
possible to add any comment text after the last bracket and it'd just ignore
it. You can even have an apostrophe like in VB to avoid inveting a wheel.

Say, such a formula including comment could be valid in a cell:
=(EOMONTH(TODAY(),0)-EOMONTH(TODAY(),-1)) 'counts number of days in a
current month.


 
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
Comments piddilin Excel Discussion (Misc queries) 8 March 22nd 05 08:57 PM
Can Comments be automatically converted to text cell values? tomdog61 Excel Discussion (Misc queries) 1 January 23rd 05 09:38 PM
comments eagles73 Excel Discussion (Misc queries) 1 January 13th 05 11:33 PM
How to change the default font and size of "comments"? ClayMcQ Excel Discussion (Misc queries) 1 January 7th 05 11:43 PM
Excel 97 Protect but allow comments sally t Excel Discussion (Misc queries) 7 December 21st 04 10:53 PM


All times are GMT +1. The time now is 06:35 PM.

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

About Us

"It's about Microsoft Excel"