Trying to format cell data HELP please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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,
 
Back
Top