>How can I format a entire column of excel using vfp?
>For example when I put a numeric value in a cell it get a cell money format.

For the following examples, assume the following:
oExcel = Instance of Excel in VFP
lcWorkbookName = The stem of the file name
lcWorksheetName = The name of the worksheet

The format will be Dollar with two decimals

To format all of column "C":
oExcel.Workbooks(lcWorkbookName).Worksheets(lcWorksheetName).Columns("C").NumberFormat = "$#,##0.00"

To format all of Row 4:
oExcel.Workbooks(lcWorkbookName).Worksheets(lcWorksheetName).Rows(4).NumberFormat = "$#,##0.00"

To format a the range A17 to C30
oExcel.Workbooks(lcWorkbookName).Worksheets(lcWorksheetName).Range("A17:C30").NumberFormat

The RANGE() property also takes RANGE(CELLS(x,y), CELLS(x,y)) if you don't know the letter of the column