Formatting problem

[Lincoln Burrows]

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

 

[ryguy7272]

I would surmise that conditional formatting is applied or you have an
event-driven macro firing. To test for conditional formatting, click on a
cell that turns green, click Format > Conditional Formatting, and see if 1,
2, or 3 conditions are listed there. To see if event-driven code is the
culprit, right-click on the worksheet tab and click 'View Code'. What you do
after that is completely up to you (the worksheet must have been set up that
way for some reason or another...)

Regards,
Ryan---