View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bodhisatvaofboogie
 
Posts: n/a
Default 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!!!!!!!