Yeah sorry, I should explain. The textbox I was using was just for my testing. The US date I want to change is in a csv file.
si_the_geek I actually did read your article, but I got confused, so I thought I'd try out some code and then if necessary ask for some help. So yeah, thanks MarkT for the assistance but as I'm sure you're now aware, CDate is good but, yeah...
"and storing the result of Format to a Date"? I don't understand that. Isn't storing it as a date a good thing? In that other thread I'm pretty sure you said to store the date using literals (#date goes here#) so it can be read correctly. But how do I do that exactly? I'm pretty tired at the moment and it's probably not the best time to be coding. So, thanks once again guys, I'll be back soon.