Hi

Excel 2000.

I use a recordset (ADO) to retrieve and loop out data into a spreadsheet.
Everything works fine except for one thing - currency data is displayed as
string data (left-aligned) in the spreadsheet. After the data is looped out
into the spreadsheet I have to manually activate the cells (using F2) and
press ENTER. Only then are the numbers correctly formatted.

The datatype in the particular column in the recordset is vbDecimal. The
numberformat of the cell in the spreadsheet is "#,##0". I've tried to
convert the decimal datatype to currency (cCur) before looping it out with
the same negative result.

Any ideas?

Regards
PO