Excel - data downlaoded to Excel, unable to change date time format
Posted on 2014-12-03
We downloaded data regularly from our CMMS software, Maximo, to Excel. However, once in Excel, we are unable to select a date/time column and format cells.
Date/time comes across as 2/22/2014 12:00 a.m.
Change: Format Cells - Date - 2/22/2014
I can change the column format and then go into the individual cell and when I type the date it converts - but does not auto convert all the date/times?