date in mm/dd/yyyy

[Guest]

I have excel sheet exported from website which already has date field and 50
rows in mm/dd/yyyy format, how to change to dd/mm/yyyy

tried Data>Text to Columns OPTION but does not work

plz help

thanks

 

[bgeier]

Select the column(s)
Right-Click
Format Cells...
(new window)
Number
Date (select your preferred format)

If the format you want does not appear, goto
Custom
In the type box, key in your format, (yyyy-mm-dd) will format the dat
as 2006-05-2

 

[Guest]

Select the cells that you want to convert and pull-down:

Format > Cells... > Number > Custom and enter dd/mm/yyy
in place of General

 

[Guest]

Tried it as well, no luck

Select the cells that you want to convert and pull-down:

Format > Cells... > Number > Custom and enter dd/mm/yyy
in place of General

 

[Fred Smith]

If you're looking for help, you need to define what "no luck" means. How else
will we know how to help you?

If you're saying that you tried to reformat the cell, and nothing changed, then
you likely have text stored, rather than an Excel date. So try this:

Enter a date in a cell, eg, 5/12/2006
Now apply the formatting changes that were suggested.
Did it change the format as expected?
If so, you now know you can reformat dates.
You simply need to change your original text to dates.