This isn't really a programming problem, but it is causing my program not
to function correctly.

I have two worksheets in the same workbook which each have a column with
the same data. The data looks like:
03-01-015
03-02-192
03A-01-099
04-02-022
etc.

Not only is the data in the two columns the same, the formats are the same.
I have tried both general and text formats.

If I sort each sheet on this column by clicking on Data/Sort... the two
worksheets are sorted differently. One sheet will be sorted as shown above
while the other will be:
03-01-015
03A-01-099
03-02-192
04-02-022
etc.

All sort parameters are the same in both sorts. There is no VBA code
associated with either page.

What could be causing the difference?

How can I fix it?


Many thanks.