text to date..!!
Hi Roger,
that would work if the OP is using UK regional settings but not if he uses
US since it will return a value error
--
Regards,
Peo Sjoblom
"Roger Govier" wrote in message
...
Hi
One way, with your date in A1, enter in B1
=--A1
FormatCellsNumberCustom dd=mmm-yyyy
Regards
Roger Govier
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
|