bluartisteyes
New Member
- Joined
- Sep 3, 2011
- Messages
- 9
I can't get dates to convert automatically anymore when copied from tv dot com and it's driving me crazy because I don't have the time it takes to change fix each one individually, I use excel to keep my place on every tv show I watch so I don't forget where I'm at in series on dvd or on tv and also helps me not to watch out of order by mistake which also drives me crazy since the writer intended it to be watched in order thus why it's called a series and not separate unrelated episodes like movies or shorts.
Can someone please tell me is there a formula that can fix this issue, I am pretty sure it's tv dot com's website that changed something with format and made it start copying as text only, but I could be wrong I also changed to the more correct date format for computer sorting yyyy-mm-dd usa even though really the setting is uk date format, I have it set to USA because I changed it in my language settings area so I don't have to change it for every excel file. So it could be that causing problem, but I don't want to go back to the bad un-sort-able USA default of mm/dd/yyyy I hate that settings it's not computer friendly and it's beyond me why anyone would want to use it.
If anyone has a solution for this I would appreciate it I have excel 2007 and it won't convert it either something isn't working right or it can't convert this type of text input from that site, I already tried the obvious right click format type text changed to date and still nothing changes, it doesn't understand the format it's getting and can't convert it to a date (I'm guessing by the way it acts). I search net and all I could find that looked promising is an add-on that the guy is selling like a yearly membership subscription at some outrageous price that I could never afford and I would never want to throw away money on a non-permanent purchase anyway if I buy an add-on I want to own it even if I never get a software update for it, I do not believe in paying for it every month or year or whatever. I just see that as a major rip off.
Can someone please tell me is there a formula that can fix this issue, I am pretty sure it's tv dot com's website that changed something with format and made it start copying as text only, but I could be wrong I also changed to the more correct date format for computer sorting yyyy-mm-dd usa even though really the setting is uk date format, I have it set to USA because I changed it in my language settings area so I don't have to change it for every excel file. So it could be that causing problem, but I don't want to go back to the bad un-sort-able USA default of mm/dd/yyyy I hate that settings it's not computer friendly and it's beyond me why anyone would want to use it.
If anyone has a solution for this I would appreciate it I have excel 2007 and it won't convert it either something isn't working right or it can't convert this type of text input from that site, I already tried the obvious right click format type text changed to date and still nothing changes, it doesn't understand the format it's getting and can't convert it to a date (I'm guessing by the way it acts). I search net and all I could find that looked promising is an add-on that the guy is selling like a yearly membership subscription at some outrageous price that I could never afford and I would never want to throw away money on a non-permanent purchase anyway if I buy an add-on I want to own it even if I never get a software update for it, I do not believe in paying for it every month or year or whatever. I just see that as a major rip off.
