I have a spreadsheet that was generated from a time logging program. It tracks badging times for employees. One of those columns is the actual time. The number is aligned to the left in the cell and excel is not recognizing it as time. Even if i highlight the cell and format it as time. The only thing that works is if I double click the cell then hit enter. Then the time shifts to align to the right of the cell (excel recognizing it as time). Any one know a work around so I dont have to double click and hit enter on 4672 cells?