What really irritates me about excel is the way it formats dates. I can
import data through a query and get a column of dates in d/m/y and it
won't format the dates the same way for the whole column. If the day is
a valid month it will swap them around.

Even if I format the column, if I copy the data to another sheet it
gets screwed up again. Then if I format the column in the new sheet it
will often be corrupted so the dates don't match the original data.

Is there something in preferences to force it to see the date the right
way?


--
fazstp
------------------------------------------------------------------------
fazstp's Profile: http://www.excelforum.com/member.php...o&userid=30574
View this thread: http://www.excelforum.com/showthread...hreadid=550196