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

[Guest]

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

 

[Guest]

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

 

[David Biddulph]

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