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 DataText 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 date
as 2006-05-28


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=546126

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

Format Cells... Number Custom and enter dd/mm/yyy
in place of General
--
Gary's Student


"Gerald" wrote:

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 DataText to Columns OPTION but does not work

plz help

thanks

Tried it as well, no luck



"Gary''s Student" wrote:

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

Format Cells... Number Custom and enter dd/mm/yyy
in place of General
--
Gary's Student


"Gerald" wrote:

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 DataText to Columns OPTION but does not work

plz help

thanks

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.

--
Regards,
Fred


"Gerald" wrote in message
...
Tried it as well, no luck



"Gary''s Student" wrote:

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

Format Cells... Number Custom and enter dd/mm/yyy
in place of General
--
Gary's Student


"Gerald" wrote:

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 DataText to Columns OPTION but does not work

plz help

thanks