When using the Financial Functions, I bring up the function pop-up box, type
in my number or cell addresses and hit enter... well I get the result within
the pop-up box, but then when I close it all I see for that cell in my
spreadsheet is the formula. How the hec do you make the entire worksheet
display the results of functions, NOT the formula???

CTRL + Caret (~)
Make sure cell isn't formatted as text

"Army Guy" wrote:

When using the Financial Functions, I bring up the function pop-up box, type
in my number or cell addresses and hit enter... well I get the result within
the pop-up box, but then when I close it all I see for that cell in my
spreadsheet is the formula. How the hec do you make the entire worksheet
display the results of functions, NOT the formula???

That isn't a caret, that's a tilde. A caret is ^
Tilde is what you wanted.
--
David Biddulph

"Tevuna" wrote in message
...
CTRL + Caret (~)
Make sure cell isn't formatted as text

"Army Guy" wrote:

When using the Financial Functions, I bring up the function pop-up box,
type
in my number or cell addresses and hit enter... well I get the result
within
the pop-up box, but then when I close it all I see for that cell in my
spreadsheet is the formula. How the hec do you make the entire worksheet
display the results of functions, NOT the formula???