Software

Question

Gravatar
Locked

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.

2 total posts (Page 1 of 1)  
+ Follow this Discussion ·
| Thread display: Collapse - | Expand +

All Answers

Back to Software Forum
2 total posts (Page 1 of 1)  

Start or search

Related Forums