Thread: Convert US date format to UK date format
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default Convert US date format to UK date format
No need for the DateSerial function. Just use

Debug.Print Format(Now, "short date")


"Carim" wrote in message
oups.com...
Hi Louise,

As a complement :
If Dat is your variable ...

Format(DateSerial(Year(Dat), Month(Dat), Day(Dat)), "Short
Date")

HTH
Cheers
Carim



Reply With QuoteReply With Quote