Thread: Find '
View Single Post
  #2   Report Post  
tjtjjtjt
 
Posts: n/a
Default

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

tj

"noyb" wrote:

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