Find '

[noyb]

I have a program which creates an Excel file but places a " ' " at the
beginning of every cell, numbers included, for example { '18.75000 }.
Reformatting the cells does not make the text a numeric. I can edit out
the ' manually but using Find And Replace produces error message that
data cannot be found. What am I missing?
Thanks

 

[Guest]

Try this in Excel to for a possible fix:
Copy a blank cell.
Select your numbers and choose Edit | Paste Special | Add.

tj

 

[noyb]

Now why would that work? Its a mystery to me but ... thanks.