EXCEL: How can you FORMAT a serial number into a MONTH ( Jan, Feb)
- by Mike
I extract the Month() number out of my date. I now want to change that number into a recognisable string Jan, Feb, Mar, etc. In Access you can use FORMAT, but what can we use in Excel?
E.g.
Date----------Formula---------Result-----What I want!
01/03/2010---Month(Date)--------3----------MAR
Thanks
Mike