View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Converting Month Number to Month Text Abbreviation

Example:
Cell A1 = 11/17/2007
Using a function/formula, I would like cell B1 to display "Nov" (without
using any date formats) . . . as if I had simply typed "Nov" (without the
double quotes) in cell B1.
I would greatly appreciate any help.
Thanks,
Bob