View Single Post
  #1  
Old 2008-11-09, 04:42 AM
desiderus's Avatar
desiderus desiderus is offline
 
Join Date: Jan 2005
Help Excel bootleg list

Hi, I'm trying to make a new bootleg list in excel, but I keep having some troubles.

I'm 'transfering' my old list which was made in html into the excel list, but I want to keep the hyperlinks to the info files. Well, this was no problem to copy/past, but after this the trouble began.

I got all the dates listed like this 03/01/94. All the dates on my list are hyperlinks to the info files. Copying these hyperlinks to excel wasn't a problem, but excel only recognize a amount of the dates as actual dates and it changes them to 1994-03-01 (for exemple).

The trouble is that on my list half of the dates are listed as 03/01/94 and the other half as 1994-03-01. I want keep the dates listed as 03/01/94, is there a possibility to turn the change that excel makes off? (2003 XP version)

I hope someone can help me.

Thanks
Reply With Quote Reply with Nested Quotes