Welcome to the Board!
A lot of times imported data can be recognized as text. If you highlight the column(s) in questions and goto Format-->Cells-->Apply your format, then goto Data-->Text to Columns-->Finish it will apply that format.
Hope that helps,
Smitty