jimrward
Well-known Member
- Joined
- Feb 24, 2003
- Messages
- 1,897
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Platform
- Windows
i guess this could be posted on either forum
I have a read only ACCESS database containing numbers to 3 decimal places in one column, for instance 124.375
In a table view in ACCESS if I copy and paste one row into EXCEL2007, I get 124.375
However I select all of the data with mouse and copy and paste into EXCEL2007, it rounds up the digits so it now reads 124.380
Any suggestions apart from pre-formatting the EXCEL sheet to the required number of decimal places
I have a read only ACCESS database containing numbers to 3 decimal places in one column, for instance 124.375
In a table view in ACCESS if I copy and paste one row into EXCEL2007, I get 124.375
However I select all of the data with mouse and copy and paste into EXCEL2007, it rounds up the digits so it now reads 124.380
Any suggestions apart from pre-formatting the EXCEL sheet to the required number of decimal places
