I have date in cell a1 with dd-mmm-yy format.
On the same sheet, I have another cell with "Allocation for " & A1
The result gives me Allocation for 39512
Required result is Allocation for 05-Mar-08

I dont understand why excel is unhappy with my format of dd-mmm-yy

Any ideas?

Regards,
Madiya