Excel changes hyperlink name on me. What gives!

I have a macro that makes a hyperlink for every file in a specific folder. I recently changed my filename stucture from 40408E(1), 40408E(2), etc. to 40408E1 and 40408E(2) (these are just examples).

Now... when excel creates a hyperlink, it doesn't give me 40408E1 it gives me 4.04E+05 and 4.04E+06


How can I have excel give the exact hyperlink I want? Is it possible?

That doesn't do anything.

That doesn't do anything.

Can you post the spreadsheet or copypasta the macro definition into a CODE tag?

Ben, Proton, as you can see, when I get a list of hyperlinks (which is what I want), it assumes 40408E1 should say 4.04+05... that's not what I want it to say.

Here is the code I use.

PHP Code: 

Sub Photo_Hyperlinks2()
Dim fs, fol, fil, count, i
count = 1
Set fs = CreateObject("Scripting.filesystemobject")
Set fol = fs.getfolder(Range("Checksheet!U4")) 'Change This Every Month
For Each fil In fol.Files
    i = Len(fil.Name)
    Do Until Mid(fil.Name, i, 1) = "."
        i = i - 1
    Loop
    Range("A" & count).Select
    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=fil.Path, TextToDisplay:=Left(fil.Name, i - 1)
    count = count + 1
Next
End Sub 


I hope this helps.

Ben, Proton, as you can see, when I get a list of hyperlinks (which is what I want), it assumes 40408E1 should say 4.04+05... that's not what I want it to say.

Here is the code I use.

PHP Code: 

Sub Photo_Hyperlinks2()
Dim fs, fol, fil, count, i
count = 1
Set fs = CreateObject("Scripting.filesystemobject")
Set fol = fs.getfolder(Range("Checksheet!U4")) 'Change This Every Month
For Each fil In fol.Files
    i = Len(fil.Name)
    Do Until Mid(fil.Name, i, 1) = "."
        i = i - 1
    Loop
    Range("A" & count).Select
    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=fil.Path, TextToDisplay:=Left(fil.Name, i - 1)
    count = count + 1
Next
End Sub 


I hope this helps.

Sorry guys, for some reason the attachment didn't go through.

Now... as you can see, when I get a list of hyperlinks (which is what I want), it assumes 40408E1 should say 4.04+05... that's not what I want the hyperlink to say.

So now that you guys can see what excel does... anyway to have excel give me the hyperlink name the way the filename is?
Where is the FORMAT() formula supposed to help here?

Any ideas to have the hyperlink names be what the file name is?

Any ideas?