I have a cell which I am unable to format. It is a time, eg 7:08. When I
select the cell and try to Format Cell, as I scroll throught the different
formats the sample does not change and when I select a format and exit the
format of the cell has not changed.
In particular, the 7:08 is positioned in the left of the cell. If I re-type
7:08 into the cell it becomes positioned in the right of the cell and I am
able to reformat it. My column has 32000 cells which have been extracted via
VLOOKUP from another spreadsheet so I do not want to have to manually
re-enter each cell so I can re-format. I am also unable to format the cells
in the original spreadsheet.

Does anyone have any ideas? The cell format is not locked and the
spreadsheet is not protected.