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.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Convert Excel Date to Numeric Text