ASP to Excel

[Esoteric]

I have got this working great with the exception of the fields format. I need a colum to be CURRENCY and it goes in as text. Is there a way to format within the fields criteria.

Example

objRS.Fields.Item(4).Value = formatcurrency(CLAMOUNT,2)

This puts in into excel like this '$400.00 so its not really currency or not a number its text.

Is there something I am missing or is this a limit?

 

[mymou]

Hi Esoteric

Are you looking for the Numberformat Property of the Range Object in Excel?

Stew

 

[Esoteric]

Sure but I am looking for the syntax to utilize it through ASP.