Try
=DATE(2000+MOD(A1,100),INT(A1/100),1)

HTH. Best wishes Harald

"bodhisatvaofboogie" skrev i
melding ...
Is there an easy way to change numbers within a cell into dates with a
format, or formula within a macro? For example:

The Number in the cells are as follows:
406 which stands for April 2006
1205 Which stands for December 2005

I want to change those numbers that are there into a nicer looking date
format, like Apr-06 or something. THANKS!!!