Hi Connull,

The Copy (blank) | Paste Special | Add process clears leading apostrophes in
text values too - at least this works for me.


---
Regards,
Norman



"Connull" wrote in message
...
Thanks Norman, this option removed the apostrophe from the numeric values
but
I am still sitting with the problem of the apostrophe in front of the text
values. If you have any further suggestions I would be most grateful.

"Norman Jones" wrote:

Hi Connull,

Copy a blank cell
Select the cells with the offending initial apostrophe
Edit | Paste Special | Check "Value" and "Add" | OK

Perhaps counter-intuitively, this works on text values.

---
Regards,
Norman



"Connull" wrote in message
...
How can I remove the apostrophe (') from the text values in my
spreadsheet. I
need to use this spreadsheet to import data into another program which
then
gives errors due to the (')