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