Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 9th 05, 11:38 PM
green opal
 
Posts: n/a
Default How do I create a footnote for a cell that holds a SUM function .



  #2   Report Post  
Old June 10th 05, 01:39 PM
Jerry W. Lewis
 
Posts: n/a
Default

Depends on what you mean by a "footnote".

Insert|Comment will let you associate a comment with the cell. This
comment will be displayed when your mouse cursor points at the red
triangle that will appear at the upper left corner of the cell.
Tools|Options|View|Comment & Indicator
will leave the comment visible so that it will appear in print-outs (you
can resize and drag to control what portions of the worksheet are
covered by the comment box)

You can write descriptive comments in any other cell to describe the
calculation.

If you want a footnote ID symbol in the cell with the formula, to tie
the cell to the descriptive comments in another cell, then things get a
bit dicey. Formatting cannot be applied to only a portion of the output
of a formula. You could use the formula
=SUM()&CHAR(134)
but the result will be text (can't be used by other formulas) instead of
a number, and the daggar symbol (CHAR(134)) will be in-line, not a
superscript. You can use the TEXT function to control formatting of the
SUM result.

You could get a similar result yet keep the cell result numeric by
appending the character in a custom format, such as
General"a"
You could get the daggar symbol by typing Alt+0134 instead of the letter
"a" between the double quotes in the custom format.

Jerry



Reply
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
Create a report with selected rows based on the content in a cell ThirdTim New Users to Excel 1 May 5th 05 05:18 PM
How do I create a Calendar Drop Down menu for a Validation cell KC73 Excel Worksheet Functions 0 April 21st 05 10:15 PM
How do you create a drop-down menu within a cell in Excel? Jimmy Excel Discussion (Misc queries) 1 March 21st 05 03:14 PM
How can i create in one cell scroll-down different options? Francisco Excel Discussion (Misc queries) 1 March 10th 05 04:17 AM
how do i create a list from a cell? AT New Users to Excel 2 December 15th 04 07:40 PM


All times are GMT +1. The time now is 03:25 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017