Hi easyway,

Copy a blank cell
Select all of your data
Right click on the selected area and choose Paste Special
Check Add and OK out.

HTH
Martin


"easyway" wrote in message
...
Hi,
My spreadsheet won't let me format an 'Email Address' or a 'Web Address'
column with active email or web addresses.

Each time I select a cell the entry in the editable bar at the top (the
formula bar) shows a ' before the text or number. If I delete the ' that
precedes the text or number, all is well and hyperlinks look like
hyperlinks
etc.....

Is there a way to remove this ' from all cells at once?