Converting Month Number to Month Text Abbreviation
=A1
Custom Format cells as mmm
"Bob" wrote:
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
|