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