Not quite sure where to put this one so I settled for "General".
I've got a spreadsheet exporting data to an Access table. The spreadsheet is formatted to display 2 decimal places, i.e. 38.50
When it's copied via vba into an Access table though it is rounding down to 38.00
I've tried various number formats in the table but wonder if it's an Excel problem in that the vba is making assumptions as to how the data should be regarded.
Is there a method of ensuring the format of data written to a recordset?
Thanks, Lol
I've got a spreadsheet exporting data to an Access table. The spreadsheet is formatted to display 2 decimal places, i.e. 38.50
When it's copied via vba into an Access table though it is rounding down to 38.00
I've tried various number formats in the table but wonder if it's an Excel problem in that the vba is making assumptions as to how the data should be regarded.
Is there a method of ensuring the format of data written to a recordset?
Thanks, Lol