By "format" I'm guessing you're only interested in the number format. (There are also fonts, fill color/pattern, borders, etc)

A column typically has more than one number format. But, even if it didn't, there's no column format display.

Since you have Excel 2007, when you click on a cell...the number format for the active cell displays in the ribbon.

I hope that helps.