Thread: Date Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hazel hazel is offline
external usenet poster
  
Posts: 114
Default Date Format
Hi

What is wrong? with the line below

ws.Cells(freerownum, 7).Value = Format(Tb1, "dd/mm/yy")

On the sheet it converts it to US Format ("mm/dd/yy")

Why?
--
Many thanks

hazel
Reply With QuoteReply With Quote