jardenp
Active Member
- Joined
- May 12, 2009
- Messages
- 373
- Office Version
- 2019
- 2016
- 2013
- 2011
- 2010
- Platform
- Windows
Here's the line
SourceWS.Cells(r,MilR) actual value is $.445 formatted as currency. The value that gets written into ImportWS.Cells(ImportAddRow, ImpRate) is $.45. Why does this round to 2 decimal places?
When I MsgBox SourceWS.Cells(r, MilR).Value is shows $.445, not the rounded number.
I adjusted the code to
and it works, so this question is more for educational purposes.
Thanks in advance!
Josh
VBA Code:
ImportWS.Cells(ImportAddRow, ImpRate) = SourceWS.Cells(r, MilR).Value
SourceWS.Cells(r,MilR) actual value is $.445 formatted as currency. The value that gets written into ImportWS.Cells(ImportAddRow, ImpRate) is $.45. Why does this round to 2 decimal places?
When I MsgBox SourceWS.Cells(r, MilR).Value is shows $.445, not the rounded number.
I adjusted the code to
VBA Code:
ImportWS.Cells(ImportAddRow, ImpRate) = SourceWS.Cells(r, MilR)
Thanks in advance!
Josh