And the formula I provided doesn't work either?  Odd.  What format is
the value in the cell? You could always strong arm Excel and cycle
through your column of data with a VBA routine hitting F2 and enter,
but that would be a last resort IMO because it forces a lot of
overhead through Excel.  If you decide to go this route, make sure
that you execute the code by going to Tools--Macro-->Macros.
Otherwise, the code will fire in the VBE and simply show the Object
Browser.
This is assuming your bad data column is A, or 1.  Simply change the
col variable to the column number containing your bad data.
Sub strongarm()
   Dim col As Integer, r As Range
   col = 1 'column number containing bad data
   For Each r In Range(Cells(2, col), _
       Cells(Cells(65536, col).End(xlUp).Row, col))
           Application.SendKeys ("{F2}~")
   Next r
End Sub