Date Formatting!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1634276%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LAB'd%20suggest%20select%20the%20column%2C%20Data-%26gt%3BText%20to%20Columns%20and%20on%20third%20step%20of%2!%20Thanks%20a%20lot......It's%20working.%20You%20made%20it%20so%20simple.%20Sir%2C%20I%20have%20one%20more%20doubt%2C%20Our%20system%20time%20format%20affects%20our%20excel%20date%20format%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1634931%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1634931%22%20slang%3D%22en-US%22%3Eand%20now%20when%20I%20am%20trying%20to%20calculate%20the%20difference%20between%20the%20dates%20it's%20giving%20me%20a%20number.%20Why%20so%20%3F%20Now%20all%20the%20dates%20are%20in%20same%20format.%20It%20should%20work%20%3F%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Dates shorter than or equal to 12 are right are left aligned.

When I am trying to change the format, it happens only for right aligned(Dates shorter than or equal to 12). Please have a look at the attached file. Please help me out !!

5 Replies
Best Response confirmed by Jagdeep_ (Occasional Contributor)


I'd suggest select the column, Data->Text to Columns and on third step of the wizard select Date and MDY


Result is


Do that column by column

@Sergei Baklan Thank you Sir ! Thanks a lot......It's working. You made it so simple. Sir, I have one more doubt, Our system time format affects our excel date format ?

and now when I am trying to calculate the difference between the dates it's giving me a number. Why so ? Now all the dates are in same format. It should work ?

@Jagdeep_ , you are welcome.

Not sure I understood next question. If you calculate the difference between two dates (like =B1-A1) excel returns the difference in days (how many days are between), that's a number.

If you'd like to have the difference like "4 years 5 months 21 day"  you may use DATEDIF. It is described with the sample here


@Sergei Baklan

Good Afternoon.

Hope you are doing well Sir !


Please find the attached.


I want all the same data in same row.


Waiting for your reply eagerly.