if your date is in cell A1 in the next cell type =datevalue(A1), then go to
format--cell-- date--choose type 14-Mar-2001 ( it is the last item).

Hope it works.
happy Holidays!

"Gord Dibben" wrote:

Select cell and DataText to ColumnsNextNext

Data Format TypeDate DMY Finish.


Gord Dibben Excel MVP

On Fri, 23 Dec 2005 12:10:43 -0600, via135
wrote:


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