Excel date conversion to accounting date [on hold]












0















Having issues convert a date in excel, to look like the following
1/1/2016. Have tried changing to a date option.



Below is what i have to work with and the option to choose either of the 2.
Jan 19, 2016
or
012016






date







share|improve this question















put on hold as unclear what you're asking by Scott, fixer1234, PeterH, Pimp Juice IT, BillP3rd 2 days ago


Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.



















  • If you remove the time, Excel will automatically treat the string "Jan 19, 2016" as the date 1/19/2016. If you insert colons before and after the minutes, if will treat "Jan 19, 2016 01:20:16" as the date/time 1/19/2016 1:20:16 AM.

    – Blackwood
    Jan 11 at 0:39











  • Is that stored as text or an Excel date/time?

    – fixer1234
    Jan 13 at 0:35











  • I reworded my question. both arre stored as text and unable to format either to the date I need.

    – Mida
    Jan 13 at 7:46
















0















Having issues convert a date in excel, to look like the following
1/1/2016. Have tried changing to a date option.



Below is what i have to work with and the option to choose either of the 2.
Jan 19, 2016
or
012016






date







share|improve this question















put on hold as unclear what you're asking by Scott, fixer1234, PeterH, Pimp Juice IT, BillP3rd 2 days ago


Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.



















  • If you remove the time, Excel will automatically treat the string "Jan 19, 2016" as the date 1/19/2016. If you insert colons before and after the minutes, if will treat "Jan 19, 2016 01:20:16" as the date/time 1/19/2016 1:20:16 AM.

    – Blackwood
    Jan 11 at 0:39











  • Is that stored as text or an Excel date/time?

    – fixer1234
    Jan 13 at 0:35











  • I reworded my question. both arre stored as text and unable to format either to the date I need.

    – Mida
    Jan 13 at 7:46














0












0








0








Having issues convert a date in excel, to look like the following
1/1/2016. Have tried changing to a date option.



Below is what i have to work with and the option to choose either of the 2.
Jan 19, 2016
or
012016






date







share|improve this question
















Having issues convert a date in excel, to look like the following
1/1/2016. Have tried changing to a date option.



Below is what i have to work with and the option to choose either of the 2.
Jan 19, 2016
or
012016






date




date






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Jan 13 at 7:44







Mida

















asked Jan 11 at 0:31









MidaMida

11




11




put on hold as unclear what you're asking by Scott, fixer1234, PeterH, Pimp Juice IT, BillP3rd 2 days ago


Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.









put on hold as unclear what you're asking by Scott, fixer1234, PeterH, Pimp Juice IT, BillP3rd 2 days ago


Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.















  • If you remove the time, Excel will automatically treat the string "Jan 19, 2016" as the date 1/19/2016. If you insert colons before and after the minutes, if will treat "Jan 19, 2016 01:20:16" as the date/time 1/19/2016 1:20:16 AM.

    – Blackwood
    Jan 11 at 0:39











  • Is that stored as text or an Excel date/time?

    – fixer1234
    Jan 13 at 0:35











  • I reworded my question. both arre stored as text and unable to format either to the date I need.

    – Mida
    Jan 13 at 7:46



















  • If you remove the time, Excel will automatically treat the string "Jan 19, 2016" as the date 1/19/2016. If you insert colons before and after the minutes, if will treat "Jan 19, 2016 01:20:16" as the date/time 1/19/2016 1:20:16 AM.

    – Blackwood
    Jan 11 at 0:39











  • Is that stored as text or an Excel date/time?

    – fixer1234
    Jan 13 at 0:35











  • I reworded my question. both arre stored as text and unable to format either to the date I need.

    – Mida
    Jan 13 at 7:46

















If you remove the time, Excel will automatically treat the string "Jan 19, 2016" as the date 1/19/2016. If you insert colons before and after the minutes, if will treat "Jan 19, 2016 01:20:16" as the date/time 1/19/2016 1:20:16 AM.

– Blackwood
Jan 11 at 0:39





If you remove the time, Excel will automatically treat the string "Jan 19, 2016" as the date 1/19/2016. If you insert colons before and after the minutes, if will treat "Jan 19, 2016 01:20:16" as the date/time 1/19/2016 1:20:16 AM.

– Blackwood
Jan 11 at 0:39













Is that stored as text or an Excel date/time?

– fixer1234
Jan 13 at 0:35





Is that stored as text or an Excel date/time?

– fixer1234
Jan 13 at 0:35













I reworded my question. both arre stored as text and unable to format either to the date I need.

– Mida
Jan 13 at 7:46





I reworded my question. both arre stored as text and unable to format either to the date I need.

– Mida
Jan 13 at 7:46










1 Answer
1






active

oldest

votes


















0















  1. "Isolate" the "Jan 19, 2016" part from "Jan 19, 2016 012016" by using left() + len() .

  2. then convert to date value using datevalue() .

  3. use formatting to get the formatting you need.


Assuming the "Jan 19, 2016 012016" is located at A1. This formula is for the step 1 & 2 : =DATEVALUE(LEFT(A1,LEN(A1)-6))



Step 3 is just a right-click (plus some other clicks) away.. ( :



Hope it helps.






share|improve this answer






























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0















    1. "Isolate" the "Jan 19, 2016" part from "Jan 19, 2016 012016" by using left() + len() .

    2. then convert to date value using datevalue() .

    3. use formatting to get the formatting you need.


    Assuming the "Jan 19, 2016 012016" is located at A1. This formula is for the step 1 & 2 : =DATEVALUE(LEFT(A1,LEN(A1)-6))



    Step 3 is just a right-click (plus some other clicks) away.. ( :



    Hope it helps.






    share|improve this answer




























      0















      1. "Isolate" the "Jan 19, 2016" part from "Jan 19, 2016 012016" by using left() + len() .

      2. then convert to date value using datevalue() .

      3. use formatting to get the formatting you need.


      Assuming the "Jan 19, 2016 012016" is located at A1. This formula is for the step 1 & 2 : =DATEVALUE(LEFT(A1,LEN(A1)-6))



      Step 3 is just a right-click (plus some other clicks) away.. ( :



      Hope it helps.






      share|improve this answer


























        0












        0








        0








        1. "Isolate" the "Jan 19, 2016" part from "Jan 19, 2016 012016" by using left() + len() .

        2. then convert to date value using datevalue() .

        3. use formatting to get the formatting you need.


        Assuming the "Jan 19, 2016 012016" is located at A1. This formula is for the step 1 & 2 : =DATEVALUE(LEFT(A1,LEN(A1)-6))



        Step 3 is just a right-click (plus some other clicks) away.. ( :



        Hope it helps.






        share|improve this answer














        1. "Isolate" the "Jan 19, 2016" part from "Jan 19, 2016 012016" by using left() + len() .

        2. then convert to date value using datevalue() .

        3. use formatting to get the formatting you need.


        Assuming the "Jan 19, 2016 012016" is located at A1. This formula is for the step 1 & 2 : =DATEVALUE(LEFT(A1,LEN(A1)-6))



        Step 3 is just a right-click (plus some other clicks) away.. ( :



        Hope it helps.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Jan 11 at 1:53









        p._phidot_p._phidot_

        633312




        633312















            -

            Popular posts from this blog

            Probability when a professor distributes a quiz and homework assignment to a class of n students.

            Image
            0 0 $begingroup$ Need help with this problem. Suppose our lazy professor collects a quiz and a homework assignment from a class of n students one day, then distributes both the quizzes and the homework assignments back to the class in a random fashion for grading. Each student receives one quiz and one homework assignment to grade. (a) What is the probability that every student receives someone else's quiz to grade, and someone else's homework to grade? (b) What is the probability that no student receives both their own quiz and their own homework assignment to grade? In this case, some students may receive their own quiz, and others may receive their own homework assignment. (c) Compute the limiting probability as n approaches infinity in each case. ...
            Read more

            Aardman Animations

            Image
            Aardman Animations, Ltd. Aardman Animations Tipo privada Atividade Animação em stop-motion , Animação em CGI Fundação 1972 Fundador(es) Peter Lord David Sproxton Sede Bristol, Inglaterra  Reino Unido Proprietário(s) Dreamworks Pessoas-chave Peter Lord David Sproxton Nick Park Divisões Aardman Features Aardman Digital Aardman Commercials Aardman Broadcast Aardman International Aardman Rights Aardman Effects Aardman 3-D Systems Aardman Nathan Love AardBoiled Website oficial aardman.com ...
            Read more

            Are they similar matrix

            Image
            0 $begingroup$ Do $begin{bmatrix} 0&i&0\0&0&1\0&0&0 end{bmatrix} $ and $begin{bmatrix} 0&0&0\-i&0&0\0&1&0 end{bmatrix} $ are similar.Is this True/false Clearly both are nilpotent and one is conjucate transpose of other but how to know if they are similar.i'm stuck. Please help me linear-algebra vector-spaces eigenvalues-eigenvectors generalizedeigenvector share | cite | improve this question edited Dec 10 '18 at 6:38 Vasanth Kris asked Dec 10 '18 at 6:19 ...
            Read more