<ddd

make that mmm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Niek Otten" wrote in message ...
| Hi Lee,
|
| =U9, Format Custom as ddd
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Lee" wrote in message ...
||I have a cell, U9 showing the date, custom formatted as dd-mmm-yy. e.g.
|| 31-Oct-06
|| I need another cell to show just the month. e.g. Oct
|| The formula =MID(U9,4,3) always returns a 2 digit number regardless of what
|| date is in U9. I assume it is the Excel date value that the MID formula is
|| taking the final two digits from.
|| How do I get it to show the month as text. e.g. Oct
||
|| Thanks,
|| Lee
||
|
|