scolty1985
Board Regular
- Joined
- Sep 16, 2009
- Messages
- 88
Im reading a value (0.8448) from sheet 2, assigning it to a variable called accountPerBase which is type currency. I then try to write that value back in sheet 1 via the following command
ActiveCell.Value = accountPerBase
but its only displaying 0.8400. When im debugging though, when i hover over the accountPerBase variable, its displaying 0.8448.
Ive changed the format of the cells to currency and 4 decimal places.
Any ideas as to why its truncating my number?
Thanks
ActiveCell.Value = accountPerBase
but its only displaying 0.8400. When im debugging though, when i hover over the accountPerBase variable, its displaying 0.8448.
Ive changed the format of the cells to currency and 4 decimal places.
Any ideas as to why its truncating my number?
Thanks