Formula Result Before Accepting, Possible?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

With Excel 2007 can you customize the formula bar to give you the result of
what you type before you hit enter? This was a nice feature in Excel 2000
with the equal ( = ) button.
 
With Excel 2007 can you customize the formula bar to give you the result
of
what you type before you hit enter? This was a nice feature in Excel 2000
with the equal ( = ) button.
Click to expand...

I'm not familiar with Excel 2000, so I don't know how the Equal Button
worked. However, if you want see the result of your formula before hitting
Enter, you can press F9... BUT to actually use (or further edit) the
formula, you MUST press Ctrl+Z (or click Undo in the Edit menu), otherwise
the calculated value will be placed in the cell, not the formula that
produced it.

Rick
 
Back
Top