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?

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?

Select a block of cells and run this small macro:

Sub tick_cleaner()
For Each r In Selection
If r.PrefixCharacter = "'" Then
r.Value = r.Value
End If
Next
End Sub

--
Gary''s Student - gsnu200745


"easyway" wrote:

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?

Sorry guys, none of the two suggestions worked thus far. It may be something
I'm doing?

Is there a way I can post a screenshot on this forum?

It's not the end of the world but just a bit puzzling that if I select a
cell with a web or emai address, it's shown on the formula bar as
'www.somethingorother.com with no hyperlink underline. If I manually delete
the preceeding ' voila! all is as it shoud be.

I've tried a simple find and replace but this won't do it for me either!

Any other suggestions for this amateur spreadsheet user would be appreciated.

Ta,

"easyway" wrote:

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?