HI,
ok getting a bit frustrated don't understand why this is not working: I have
following
info has headers in Row1
Prodgr part#, 04/04/2005 04/09/2003 04/11/2003 05/12/2005
05/22/2003

I want to sort the dates left to right so should be
04/09/2003 04/11/2003 05/22/2003 04/04/2005 05/12/2005
I did the data--sort--options--left to right, but it doesn't work.
Yesterday I tested and did work.
FYI, the format shows General, but if I try to format as date it doesnt' do
it. But if I go into the cell and hit enter then it does change the format.
Why would I have to go into the cell and hit enter? Once I do this, then the
Left to right works.

Can anyone have help with this?


Thanks,
Juan