>Hi All,
>
>This is a hard one: I have some data, which I need to send to Excel. This data is a collection of numeric values, logical expression and characters within the same column. To sort this problem, I have transferred all the values to characters making logical Yes and No and numbers STR(). After that
>I EXPORT it to Excel.
>
>The problem is that when it goes to Excel, I cannot format the numeric cells from VFP, because they are all interperted as characters. Even when I go to Excel itself and try to format the cells, it does not respond.
>
>Is there any other way to sort it out?
>
>Thanks
>
>Jonathan
Instead of copying to Excel, try some other alternatives: Automation, or copy to file (type FoxPlus) and import from Excel.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)