The Traders' Den  

  The Traders' Den > Where we go to learn ..... > Technobabble
 

Notices

Technobabble Post your general Need for Help questions here.
Lossy or Lossless?
Moderators

Reply
 
Thread Tools
  #1  
Old 2008-11-09, 04:42 AM
desiderus's Avatar
desiderus desiderus is offline
42.56 GB/40.83 GB/0.96
 
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
  #2  
Old 2008-11-09, 06:34 AM
jmusiclover's Avatar
jmusiclover jmusiclover is offline
62.58 GB/68.02 GB/1.09
 
Join Date: Sep 2006
Re: Help Excel bootleg list

Select the cells to change -> Format -> Cells -> [pick date category] -> Change Type.

If you want the day/month order switching just change the location.
Reply With Quote Reply with Nested Quotes
  #3  
Old 2008-11-09, 06:47 AM
pattison2's Avatar
pattison2 pattison2 is offline
86.00 GB/209.64 GB/2.44
 
Join Date: May 2008
Re: Help Excel bootleg list

change the type to "text" to make it acceptable to any date format
Reply With Quote Reply with Nested Quotes
  #4  
Old 2008-11-09, 06:50 AM
desiderus's Avatar
desiderus desiderus is offline
42.56 GB/40.83 GB/0.96
 
Join Date: Jan 2005
Re: Help Excel bootleg list

LOL got it! That was easy :P Thanks a lot
Reply With Quote Reply with Nested Quotes
Reply

The Traders' Den > Where we go to learn ..... > Technobabble

Similar Threads
Thread Forum Replies Last Post
List of Bootleg sites (Like TTD) - calvin1663 Technobabble 91 2014-02-27 07:38 PM
My dvd bootleg list - thomas12 Snail Mail Trading 0 2008-06-27 03:16 AM
[LPRT] My Bootleg list!. - >>In The End<< Snail Mail Trading 1 2008-02-09 05:57 PM
? re: List and Excel - AAR.oner Technobabble 3 2005-04-02 04:55 PM


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forums


All times are GMT -5. The time now is 02:53 AM.


Powered by: vBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright ©2004 - , TheTradersDen.org - All Rights Reserved - Hosted at QuickPacket
no new posts