Thank you..

Also found a really good macro to use:

Sub RemoveApostrophe()
' Removes hidden apostrophes as first character
' Works on formulas as well as text and values
For Each CurrentCell In Selection
If CurrentCell.HasFormula = False Then

'Checks to make sure that procedure does not
'change cell with a formula to be only the value
CurrentCell.Formula = CurrentCell.Value
End If
Next

End Sub