I am trying to figure out how to convert 01/01/2009 (Excel Date) to 0109 (Text). I have tried =TEXT(DateCell,”0″) and =TEXT(DateCell,”mmyy”) with no success. Doing the latter always gets me 0100 regardless of the date I have in the cell i’m getting the date from. Any help is greatly appreciated.
