E
Elessvie
Dear kind and wise people,
Can someone please help me. I cannot figure out what's wrong with my
formatting. I have searched this terrific board for an answer, but can't
find exactly the solution, and now time has run out, so I'm asking directly.
Have a column A1 with dates spelled out as follows:
Wed Mar 04 2009 15:01:59 EST.
I am trying to convert this into B1 in the format :
04-Mar-2009.
ATTEMPT #1 --
Here is what I have tried in Column B:
=MID(A1,5,11)
And I have chosen the Date format for Column B to be 04-Mar-2009
But no matter how I format Column B, it displays as
Mar 04 2009
ATTEMPT #2 --
I have typed in Column B
=DATEVALUE(MID(F27,5,11))
The cell now displays the error
#VALUE!
The columns are NOT protected. I have Excel 2007, working in a .xls
document in compatibility mode.
Can someone please tell me what's wrong?
Many, many thanks,
-Lynne
Can someone please help me. I cannot figure out what's wrong with my
formatting. I have searched this terrific board for an answer, but can't
find exactly the solution, and now time has run out, so I'm asking directly.
Have a column A1 with dates spelled out as follows:
Wed Mar 04 2009 15:01:59 EST.
I am trying to convert this into B1 in the format :
04-Mar-2009.
ATTEMPT #1 --
Here is what I have tried in Column B:
=MID(A1,5,11)
And I have chosen the Date format for Column B to be 04-Mar-2009
But no matter how I format Column B, it displays as
Mar 04 2009
ATTEMPT #2 --
I have typed in Column B
=DATEVALUE(MID(F27,5,11))
The cell now displays the error
#VALUE!
The columns are NOT protected. I have Excel 2007, working in a .xls
document in compatibility mode.
Can someone please tell me what's wrong?
Many, many thanks,
-Lynne