Date format

Closed
Nisha - May 15, 2015 at 09:43 AM
 Blocked Profile - May 15, 2015 at 05:19 PM
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...

1 reply

Blocked Profile
May 15, 2015 at 05:19 PM
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!
0