Format Cell Question
I have data Imported into cells from another program. The data is a date,
and it comes into the cell as follows:
April, 2006 = 406
December, 2006 = 1206
etc, etc...
Now, I want to format the cells such that they change to
Apr-06
Dec-06
I have been messing around trying to figure out a custom format, and have
had no luck. What am I missing? Ultimately I'll incorporate this into a
macro, SO, if there are some CODE solutions, bring em on. THANKS!!!!!!!
|