>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