Software

Ask something
Question Locked

Convert Excel Date to Numeric Text

0 helpful
3 replies

by zayasj1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

3 replies

by robo_dev

then you need to trim the day off, if that's what you want

01/01/09 text(A1,"mmyydd") LEFT (B1,4)
A1 B1 C1
01/01/09 010901 0109

=LEFT(resultcell,4)

you could nest the two functions together.

This discussion is closed to new replies.