Date format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

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.

Ask a Question

Similar Threads

Convert dates stored as text 2
Excel 2002: How to make the date format uniform ? 1
Formatting Dates from Text to Numbers 2
Date Formats 1
date 1
Date format changes in mail merge using Excel worksheet as data 2
Date automatically swaps 6
Changing date to eliminate day in format mm/dd/yyyy 1

Back
Top