Thread: English and American dates...
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
  
Posts: 2,824
Default English and American dates...
Or just use a number format????

wrote:

Actually I might have sorted this using the xlPasteValue
variable.

This pastes the dates as a serial number.

I think I can retrieve the correct parts of the date using
the DAY, MONTH, YEAR functions.

Nick

--

Dave Peterson

Reply With QuoteReply With Quote