Macro with Sendkeys no longer works

I had a macro that used to work (Excel 2010). We recently upgraded to Windows 8, and it no longer works the way it's supposed to.

I receive data as text. I combine two fields, then hit a macro button to convert it to General format. Pretty simple. Here is the original macro:

Sub General_Format()
'
' General_Format Macro
'

'
ActiveCell.Select
Selection.NumberFormat = "General"
ActiveCell.Select
SendKeys "{F2}", True
SendKeys "{ENTER}", True
ActiveCell.Offset(-1, 0).Select
End Sub


In the attached file, cell B3 has the formula I typed. When I hit the macro, it should change the format to General, hit F2 (I don't know why I have to do this to get it to "take", but I do), then hit Enter. Then I have it move back up a cell, since hitting Enter moves down one cell.

Cell B2 shows what happens when I do the above manually, but I don't know why the macro no longer works properly.

After some checking online, I tried adding in a Wait line, but that didn't fix it.

Any help is appreciated!

Exactly what I explained in my original post and in the example.

I can change the format of the cell to general, but when I do, I still see the formula, not the result. I can't copy it down, because it copies the same formula, referring to the same cells as the original. The only way I've found to deal with that is to hit F2 then hit Enter, then go back to the cell (because hitting Enter moves down a cell, per my desired settings). I do this often enough that it made sense to have a macro that does it so I can click a button.

I'm certainly open to a better way to do it.

Norie, that works, but it's quicker if I do it with my method. Saves steps. I could probably write a macro to change the format of the current column to General, which I will do if I can't get this one to work. Thanks for the suggestion.

Norie, I use this in a lot of different files, so it's not always the same formula, but I can write a macro that will both insert the column (that's usually the first step) then format it as General, and that should solve my problem.

If you have the time and inclination, how would I then get it to wait until I put the formula in, then copy it down for me, then paste the values where the formula is?

(It's like asking the smart kid to do my homework for me.)

Thanks!