date in mm/dd/yyyy

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

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
 
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
 
Select the cells that you want to convert and pull-down:

Format > Cells... > Number > Custom and enter dd/mm/yyy
in place of General
 
Tried it as well, no luck



Gary''s Student said:
Select the cells that you want to convert and pull-down:

Format > Cells... > Number > Custom and enter dd/mm/yyy
in place of General
Click to expand...
 
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.
 
Back
Top