Hello,

I recently downloaded some data that includes a column of date time information. The date time appears as one number (ex: 201206010053 for 2012-06-01 00:53). I though that I could change the number into a date time format by using the custom option under the format cells number option. However, I entered yyyy-mm-dd hh:mm into the custom format option and got ############# as the output for the date times. Any suggestions of what I must do to change 201206010053 to 2012-06-01 00:53?

Thank you!

Screen shot 2012-12-05 at 9.46.47 AM.png