One fairly easy solution, select the cell/column with the text dates,
do datatext to column, click next twice and under column data format
select date and from the dropdown select DMY and click finish, this will
change it to a numerical date and then you can just use custom format like

dd-mmm-yyyy



--

Regards,

Peo Sjoblom


"via135" wrote in
message ...

sorry! a small correction!

if i am having a date in a cell as 30/11/2005 but formatted in text,
what's the procedure to change the same to date format as
"30-Nov-2005"?

thks & regds!

via135






via135 Wrote:
if i am having a date in a cell as 30/11/2005 but formatted in text,
what's the procedure to change the same to date format as
"30-Mar-2005"?

thks & regds!

via135


--
via135
------------------------------------------------------------------------
via135's Profile:
http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=495816