• 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.

Need convert dates in to general format

S

seansr

Member
I have a spreadsheet with some 30,000 rows and there is a column C with dates typed in they show like this for example23 January 1920, 26 January 1915, 05 November 1909, 09 January 1911

but mainly are entered in format like 23/01/1920, 26/01/1915, 05/11/1909


I need to take this date and convert it into a general format such as 19200123, 19150126, 19091105 for example in column D


I can do something like this in column D =c? and format it yyyymmdd, but then it is in the wrong format. If I copy the data and paste values only and then format it back to general it converts it to s serial number


Can anyone help
 
Hi seansr,


Can you please try the below formula in D2..

Code: 
=TEXT(C2,"yyyymmdd")
and drag the same..


Please upload sample workbook, if the above will not work :)


Regards,

Deb
 
That's absolutley fabulous.


the only other way was doing it manually


and in the 11th hour a saviour, I was going to have to let someone down


Many thanks
 
Hi seansr,


Can you please try below method. (For Filter it will differ from Deb method)


1.select entire column(C)

2.Press Control+1

3.Under number go to custom and paste yyyymmdd (Below type)


Thanks,

Suresh Kumar S
 
You must log in or register to reply here.
Back
Top