I'm guessing that your dates were imported as Text fields, rather than dates.
Thus, no matter what Date Format you apply, you won't see any changes. This
should be identifiable by an apostrophe at the beginning of each date that is
only visible in the Formula Bar, not the cell.

Follow these steps to remove the apostrophes.

Enter a 1 into any blank cell.
Copy that cell.
Select your range of dates.
Paste Special
Check the box called "Multiply"
Click OK
Delete the 1 you entered originally.
Now, try applying your desired Date Format and see if it works.

HTH,
Elkar


"bodhisatvaofboogie" wrote:

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!!!!!!!