Date format

S

Shaheed

I receive data in different "formats". Excel recognizes the date as dd/mm/yyyy, but sometimes I get data with the date specified as mm/dd/yyyy. For example, my date column can have a dates such as 09/23/2003. How can I convert the date data I receive to be read by Excel as mm/dd/yyyy?
Thanks
Shaheed
 
D

Dave Peterson

How you do get this data?

Does it come as an ASCII file (.txt or .csv)?

If yes,
(Rename your .csv to .txt before starting)

then do File|open and you'll get a text to columns wizard. Then specify each
date field the way you want mdy, dmy, etc.
 
Top