text to date..!!
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
|