D
Dave
Hi all,
This has me stumped.
I'm transferring a recordset from Access97 to Excel2000 using automation
(CopyFromRecordset). The Worksheet has the desired range formatted as numbers
with two decimal places as does each of the corresponding columns in the
query. After the transfer takes place, column D in the worksheet becomes a
date, for example D3 shows 15/05/1900 instead of 136.00. I've tried shifting
the columns around in the query, but it's always Column D in the spreadsheet
that is formatted this way. I've deleted the worksheet and created a new one
only to get the same results. Can anyone suggest a way to make sure the
required range of cells are in a number format AFTER the recordset has been
copied?
Thanks
Dave
This has me stumped.
I'm transferring a recordset from Access97 to Excel2000 using automation
(CopyFromRecordset). The Worksheet has the desired range formatted as numbers
with two decimal places as does each of the corresponding columns in the
query. After the transfer takes place, column D in the worksheet becomes a
date, for example D3 shows 15/05/1900 instead of 136.00. I've tried shifting
the columns around in the query, but it's always Column D in the spreadsheet
that is formatted this way. I've deleted the worksheet and created a new one
only to get the same results. Can anyone suggest a way to make sure the
required range of cells are in a number format AFTER the recordset has been
copied?
Thanks
Dave