G
Guest
In excel the date format is as mm-dd-yy. In my imported data(Btree) the
format is dd-mm-yy. So I want to change the format as dd-mm-yyyy
format is dd-mm-yy. So I want to change the format as dd-mm-yyyy
Dan said:Aivis,
This is close to my problem. I'm importing text and one of the columns is a
date/time inthe format "Fri Aug 22 13:49:20 EDT 2003" and I'm trying to get
this into an excel format that I can then use for sorting. Would this
method, or something like it, work for my problem? And how, setting the
column format to a date format hasn't worked and I can find documentation on
how to specify custom formats to solve this.
Thanks,
~Dan
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.