I often use a formula similar to that one to "carve data in stone" to prevent
changes in calculated values. Figured the Copy/Paste Special would be a
little faster for you, although there are times it can fail. Glad this
wasn't one of them, or else we would have been forced to use the code you
found.

Enjoy.

"James T" wrote:

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