How do I convert a formula to a value please?

[Richard_Howard]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

In Microsoft you hit F2 to edit the cell, and then hit F9 to convert a formula to a value. For example, if cell A1 = 2, and cell A2=5, then if you have a formula A1+A2 in cell A3, it returns the sum, which is 7. Well, I can't find out how to do this in Excel for Mac. I know you hit CTRL-U to edit, but what do you do next?

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

In Microsoft you hit F2 to edit the cell, and then hit F9 to convert a formula
to a value. For example, if cell A1 = 2, and cell A2=5, then if you have a
formula A1+A2 in cell A3, it returns the sum, which is 7. Well, I can't find
out how to do this in Excel for Mac. I know you hit CTRL-U to edit, but what
do you do next?

The easiest way is to select the cell, copy it, and then choose Edit-paste
special and click values.

 

[Richard_Howard]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

In Microsoft you hit F2 to edit the cell, and then hit F9 to convert a formula
to a value. For example, if cell A1 = 2, and cell A2=5, then if you have a
formula A1+A2 in cell A3, it returns the sum, which is 7. Well, I can't find
out how to do this in Excel for Mac. I know you hit CTRL-U to edit, but what
do you do next?

The easiest way is to select the cell, copy it, and then choose Edit-paste
special and click values.
[/QUOTE]

Hello, the above solution is very time consuming, no? In Vista you hit F2, F9 and then Enter. The above is about six keystokes, which is way slower. (I know, I tried). Is this really the only solution? Often, I will hit F2, F9 just to see what the formula evaluates to, then hit ESC to go back. The above solution just does not allow you to be quick when checking data.

 

[CyberTaz]

Go to Tools> Customize Keyboard, select Edit from the Categories: list
select Paste Values in the Commands list, then enter a keystroke [I use
Command+Option+V] into the "Press new shortcut key:" field & click Add
followed by OK.

From then on you'll have your 2-stroke process - once you select the cell:

Command+C to copy, then
Command+Option+V to Paste Value

I'm not sure what you mean by "Often, I will hit F2, F9 just to see what the
formula evaluates to". What the formula evaluates to is already displayed in
the cell before the copy/paste, is it not?

If you're looking for the quickest way to reverse the paste value process
just use Command+Z to undo.

HTH |:>)
Bob Jones
[MVP] Office:Mac