Hi all,

I need to manipulate a LOT of historic excel files that had a LOT of
different people that did the original data entry. The data are in
columns, and consist of dates (Column B) and numeric values (Columns
C- NN). But some of the date and numeric values are stored as text
(as indicated by the little green triangles in the upper left corner
of the cell), depending on who did the original data entry. When I
try to re-format the date or numeric data by selecting the column and
then format and then date or number) either manually or in a macro,
the format command does not reformat the cells that were originally
formatted as "text".

What am I missing? Any help appreciated,

Thanks a heap,
-Zx