date conversion

[Muthukrishnan V]

Excel 2007
Column A contains dates in dd-mm-yy format.
How to convert the dates into dd-mm-yyyy format?
Example: 28-02-09 to 28-02-2009
Thanks

 

[Michael M]

Select Col "A"
Rclick>>Format>>Date>>Select required date format in RH window

OR

Rclick>>Format>>Custom>>In the type window>> dd-mm-yyyy >>OK

 

[Muthukrishnan V]

Sir, I could not achieve result.

 

[Michael M]

Are they actual dates (right formatted) or text dates(Left Formatted) ??