Time not formatted

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?

Highlight that column, click on Data | Text-to-columns, then click Finish.

Hope this helps.

Pete

Pete,

Thought I tried that already . Dead on man. Thanks

You're welcome - thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete