Convert Excel Date to Numeric Text

By zayasj1 ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums