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?