hi
thks everyone for ur immediate response!
via135
Peo Sjoblom Wrote:
This won't work if the OP is using US regional settings which I suspect
he/she might do
--
Regards,
Peo Sjoblom
"Nikki" wrote in message
...
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
--
via135
------------------------------------------------------------------------
via135's Profile:
http://www.excelforum.com/member.php...o&userid=26725
View this thread:
http://www.excelforum.com/showthread...hreadid=495816