Format the destination cells as text
Click Edit-Paste Special, and select text and then click on ok
Click Data-Text to Columns
Select Delimited, and click next
Deselect all delimiters, and click next
Select Date and DMY, and click finish

All entries should now be dates. They might be formatted like

mm/dd/yy

but you can change the format to this

dd/mm/yy


"Sameer" wrote:

Hello,
I am having some data in my worksheet which I have pasted from a
database.
There is one column containing dates.
Here in India,we follow dd/mm/yyyy date convention.
So when the date is of the format 28/09/2006, i.e. when the day is
greater than 12, the entries in the cell are interpreted as text values
and they are left aligned.
The other dates are treated normally but still Excel treats that the
month being day and day being month.
This is large database so what to do to treat them as dates in Excel in
dd/mm/yyyy.
I am using Windows 2000. Do i need to use Control Panel Regional
Settings?

One solution for me is to extract day, moth and year from text and
forming date using these values using the DATE function.

Please comment.