Date format

Closed
Nisha - 15 May 2015 à 09:43
 Blocked Profile - 15 May 2015 à 17:19
Hello,

I am using office 2013. However for some data dump I am getting date format for dates between 1to12 , however for dates 13 onwards it turned out to be text format...
Related:

1 response

Blocked Profile
15 May 2015 à 17:19
We are volunteers on the forum, and in order to help you in the most efficient way possible, we need the problem you are facing, as I can post a couple of solutions that would qualify as an answer, but not YOUR Answer.

Please post back with what format you are attempting to change it to. Like:
=TEXT(B2,"mm-dd-yyyy")

In this example, the date in cell B2 would then be converted to a two digit month, day, and four digit year!