Excel is seeing the date as dd/mm/yyyy

L

Lisa

I have a column of dates that I'd like to use in a formula. Problem is Excel
sees the dates as dd/mm/yyyy when they are actually entered as mm/dd/yyyy.
For example the date entered in the cell is 10/17/1980 and Excel see the 17
as the month.

A second question although not as important as the first is, and I have seen
this before in other spreadsheets, why is it in that column of dates some of
the cells are actually seen as mm/dd/yyyy and some seen as dd/mm/yyyy.

Manual formatting does not work at all. I am thinking I need a formula to
switch the month and date around.

Thanks so much.
 
J

Jacob Skaria

Dear Lisa

I think the basic issue you have is the format in which you have your data
in the sheet. Is that imported from somewhere or a csv file which you have
opened..

Try this....
Select the column-->From menu..Data-->Text to Columns..Next..Next will bring
you to the Wizard Step 3 of 3

Then select Date option button and select the format you require. MDY or DMY
as required . Hit Finish..


If this post helps click Yes
 
L

Lisa

Thanks so much Jacob,

Not sure where the data came from but it certainly would make sense.

Thanks again
 

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

Top