And it surely makes it easier to understand what 01/02/03 means when it's
formatted in an umabiguous date format.

I'm still learning that lesson <vbg.



joel wrote:

I don't like when I get a posted worksheet data from England that have
to fix the dates before I can paste data into a worksheet, but there
isn't much I can do about the problem. It would be nice if could format
the column on the worksheet that you are putting in a foreign date and
excel would automatically do the conversion. Microsoft doesn't have any
solution to this problem.

--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=193373

http://www.thecodecage.com/forumz

--

Dave Peterson