• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Making date information workable

Uzzal

Uzzal

Member
I got a huge data where date information is entered as 20/10/2014(day_month_year) in general format
is it possible to change it as10/20/2014 (month_day_year)to make it workable in date format?
 
Uzzal said:
I got a huge data where date information is entered as 20/10/2014(day_month_year) in general format
is it possible to change it as10/20/2014 (month_day_year)to make it workable in date format?
Click to expand...
Hallo Uzzal

Can u please upload a sample file,,, or just use format cell option...
 
Hi Uzzal,

Any valid date which in entered in Excel in whatever format, is workable for all sort of calculation.

Format is just the upper appearance inside excel treat dates as serial number.

I assume when you say date in general format it is entered as TEXT. If so, you can use DATEVALUE function to convert it to proper date and than you can apply mm-dd-yyyy format to t.

Regards,
 
Another approach.

Select column with dates say column A. Go to Text-To-Column and go till the last option . Select date there. Click OK.

Than format the column as mm-dd-yyyy.

So this way you do not need and formulas.

Regards,
 
You know something ? I love you people! ha...ha..ha....ha.....never felt so supported before for excel learning, so prompt, & easy solution seems like you are coming out from the lamp of Aladin,(Now its mine lamp)
I wish If I could contribute thanks giving to NINJA's now.Though I am not in a position to do it in this very moment But Yes I will make it happen,all that I need some time, & definitely that would be a very little gratitude from my side in respect of the grate support I am receiving & the way it helps me to develop my professional skills.Hope to hang with you freinds for many more amazing things
 
@Uzzal

Don't worry, we all were there at some point of time and we are still there at some point of time now also. Keep Learning and spreading the knowledge that you gain, that is the best way to learn. There are many users here who are not NINJA but they give awesome results.

Happy Learning and thanks for your kind words.

Regards,
 
You must log in or register to reply here.
Back
Top