Want to display financial formula result... not the formula
 

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

Want to display financial formula result... 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???

Want to display financial formula result... 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???