Send Object (Excel) cell format

[kbestle]

I am sending the data from a crosstab query to a mail receipient as an Excel spreadsheet. There are 5 columns in the spreadsheet that provide the person fields to enter a price. These cells by default have a format of General which does not work for entering currency values. Is there a way to force the cell format in Excel to be number with 4 decimal places?

Thanks
Kent

 

[SkipVought]

See thread68-913190

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}