excel 2002 convert numbers to mathematical

anon125

Active Member
Joined
Feb 14, 2008
Messages
343
Remove the hyperlinks
Replace with the $ in the replace with box and the other box blank.
great! how do i do that?
thanks
 

MARK858

Well-known Member
Joined
Nov 12, 2010
Messages
11,329
Office Version
365, 2010
Platform
Windows, Mobile

anon125

Active Member
Joined
Feb 14, 2008
Messages
343
right click does not have the remove hyperlinks option.
it has one for hyperlinks.
thanks
 

MARK858

Well-known Member
Joined
Nov 12, 2010
Messages
11,329
Office Version
365, 2010
Platform
Windows, Mobile
Can't help you there as it does on mine if there are hyperlinks (and nothing if there isn't hyperlinks). You will have to look up how to do it in 2002 as I don't have a copy in front of me. You could try copying the column and pastespecial as values.

Or try running the sub below

Code:
Sub RemoveHyperlinks()
ActiveSheet.Hyperlinks.Delete
End Sub
 

MARK858

Well-known Member
Joined
Nov 12, 2010
Messages
11,329
Office Version
365, 2010
Platform
Windows, Mobile
P.S. when you do the replaces make sure that match entire cell contents under options is not checked.
 

anon125

Active Member
Joined
Feb 14, 2008
Messages
343
went to another computer. both win7 both same version of excel.
those with a minus sign do not give the remove hyperlink option.
the positive numbers do give that option!
BTW i used to live in havant - also in southern england!
thanks
UPDATE they both now remove hyperlink but it is still text. will try the multi option
that only works on the positive ones!!!!
 

anon125

Active Member
Joined
Feb 14, 2008
Messages
343
i am going to make a completely new file from scratch and use what you folks have kindly taught me.
thanks
 

MARK858

Well-known Member
Joined
Nov 12, 2010
Messages
11,329
Office Version
365, 2010
Platform
Windows, Mobile
You need to do the 2 replaces as well as the remove hyperlinks (you don't need to select the individual cells, you can do the whole column in one). Btw Havant isn't far away from me :ROFLMAO:

If you could post the actual file the I would do it for you but as that isn't an option maybe you could copy/paste the offending column to a different workbook then I could convert it, repost it and then you could paste it back rather than creating a whole new file.
 

Forum statistics

Threads
1,078,253
Messages
5,339,110
Members
399,279
Latest member
danidanidaniel

Some videos you may like

This Week's Hot Topics

Top