Hyperlinking in Excel

I need a clarification....

Are you saying that:
Col_A will still contain the hyperlink destination text
and
Col_E will contain a numeric value
AND
you want to only create hyperlinks in Col_A where the
corresponding Col_E value is greater than zero?

OK.....Try this:

Sub ConvertTxt2HyperlinkInColA()
Dim cCell As Range
Dim strPath As String

strPath = ""
For Each cCell In Selection.Cells
    If cCell.Offset(ColumnOffset:=4).Value > 0 Then
        On Error Resume Next
        ActiveSheet.Hyperlinks.Add _
            Anchor:=cCell, _
            Address:=strPath & cCell.Value, _
            TextToDisplay:=cCell.Value
    End If
Next cCell
End Sub

Before running it....select the Col_A cells.

Is that something you can work with?