ActiveCell.Value = accountPerBase only displays 2 of 4 decimal figures

[scolty1985]

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

 

[sijpie]

I guess it has to do with setting the accountPerBase type as currency. Why is this required? I would just keep it as double.

 

[ManxDom]

try using ActiveCell.Value2 = accountPerBase

found this in thread http://www.mrexcel.com/forum/excel-questions/358339-glitch-currency-format.html

 

[scolty1985]

Both work. Thanks very much guys, i really appreciate it!