>I have a program that creates an Excel spreadsheet with one column that is dollars and cents. Excel drops the
>cents if they are zero. Using Excel afterward, if I right-click the column heading, such as B, I can click formatting
>and put in either numbers or money and correct the problem. However, I can not find out how to do this in
>Foxpro. Where can I find out all the properties and so forth for Excel.
>
>Joel
There is NumberFormat property in Excel.
Check
Re: Formatting a column in Excel Thread #
1253496 Message #
1253503
If it's not broken, fix it until it is.
My Blog