S
Scarab
I am trying to Copy Currency Data from an Access 2003 Database into Excel
2003. The Cells in Excel are formated to accept 5 decimal places but when I
Special Paste (to preserve the background settings of the worksheet) the
Values are rounded up to 2 decimal places. This only happens when bulk
copying and pasting cells.
Example £2.12345 in Access when pasted into Excel becomes £2.12000 using
fixed decimal places or £2.12 if not.
2003. The Cells in Excel are formated to accept 5 decimal places but when I
Special Paste (to preserve the background settings of the worksheet) the
Values are rounded up to 2 decimal places. This only happens when bulk
copying and pasting cells.
Example £2.12345 in Access when pasted into Excel becomes £2.12000 using
fixed decimal places or £2.12 if not.