View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lincoln Burrows Lincoln Burrows is offline
external usenet poster
 
Posts: 4
Default Formatting problem

Hi
I'm using VFP to create excel file.
loExcelSession.Cells(lnRow,lnCol).VALUE = lcData
Before setting the value I format the column according to the data format,
but when entering dates in to the column it displays with green color
hyphen. what is the reason for this