# (Solved) Converting a date from 00/0000 to 00/00/0000

1. ## (Solved) Converting a date from 00/0000 to 00/00/0000

Hello,

I am working on setting up a new date converter as were switching software and need to transfer numerous data sets. I am currently trying to convert a date from 00/0000 (which is currently acting as a number) to 00/00/0000. Any ideas? Thanks in advance for the help!  Register To Reply

2. ## Re: Converting a date from 00/0000 to 00/00/0000

so, going from this... 00/0000 to this 00/00/0000, how is someone to know what those numbers represent? 00/0000
can you give an actual example of each number and are we to assume it will all be in excel?  Register To Reply

3. ## Re: Converting a date from 00/0000 to 00/00/0000

I appreciate your comment, and apologize for the lack of context as it is my first time posting. I am using Microsoft Excel and for example I am trying to convert 12/2019 (today's date without the specific day) to 12/01/2019. So currently the 12/2019 is defined as a number, and I would like to convert a specific date from the original context of 00/0000 to 00/01/0000. Thanks again for the feedback!  Register To Reply

4. ## Re: Converting a date from 00/0000 to 00/00/0000

this would be one way... =IF(LEN(A1)=7,DATEVALUE(LEFT(A1,2)&"/01/"&RIGHT(A1,4)),DATEVALUE(LEFT(A1,1)&"/01/"&RIGHT(A1,4)))
BUT, I don't know if when you have 9/2019 that it isn't 09/2019 instead of 9/2019. So that is why I added the LEN formula into the datevalue formula.  Register To Reply

5. ## Re: Converting a date from 00/0000 to 00/00/0000

I have dropped a test excel in the comments here. The data set I am working with does not include a zero before a one as such (1/2019) - Which is the way its currently formatted. Although if the date was October of 2019 it would show up with 10/2019.  Register To Reply

6. ## Re: (Solved) Converting a date from 00/0000 to 00/00/0000

=date(right(a2,4),--(left(a2,len(a2)-5)),1)  Register To Reply

7. ## Re: Converting a date from 00/0000 to 00/00/0000 Originally Posted by RigbyDigby So currently the 12/2019 is defined as a number
What do you mean by "is defined as a number"? What number? Is it 43800? If so, it is already the date you want and all you need to do is format the cell using the date format of your choice.  Register To Reply