View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Megadrone Megadrone is offline
external usenet poster
 
Posts: 21
Default Apostrophes in Cell

I create a formula in a cell, I take the result (a number) and copy (values
to get rid of the formula) it into a cell to the left. When done there is an
apostrophe at the beginning of the number.

How can I get rid of this apostrophe with find/replace command. I have tried
everything, it just comes back teling me it can not find a data...


PS.

I'm doing this with about 33,000 lines of data.