Excel 97 file should have DATE columns formated to mm/dd/yyyy. Also the file should have TIME columns formated as hh:mm (AM/PM).
The file is opening up with these columns converted to numbers.
When cell is selected, the edit box shows the correct format, but the cell still has numbers.
Also some colums will not center, even after format applied.
Have done Format/Cell/and choose correct date format, but it is not formatting.
Tried deleting cell and re-typing -nothing.
I would rather not have to delete colums as there are over 8 columns affected.
