Thread: Numberformat issue
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Die_Another_Day Die_Another_Day is offline
external usenet poster
  
Posts: 644
Default Numberformat issue
I use the column number like this:

Columns(i).NumberFormat = "yyyy/mm/dd"

where i = column number

Die_Another_Day

Reply With QuoteReply With Quote