Thread: Date Format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
  
Posts: 2,452
Default Date Format
What is Tb1?

RBS


"Hazel" wrote in message
...
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