Range Copy loses precision with accounting type

[omarazam]

I am using a range copy and paste for cells that have accounting type with 4 decimal precision and I am losing precision in the target cells! Is this just a bug or is there a way to preserve the 4 decimal precision?

For example, sheet1 has following 4 cells:

$0.2343 $0.2343
$0.2343 $0.2343

My macro has one line of code:

Please Login or Register  to view this content.

Sheet 2 now has:

$0.23 $0.23
$0.23 $0.23

[Richard Schollar]

Hi

I expect it is simply down to the format of the cells - try:

Please Login or Register  to view this content.

Richard

[omarazam]

Hi

I expect it is simply down to the format of the cells - try:

Please Login or Register  to view this content.

Richard

That didn't work either. It is still truncating the 3rd and 4th decimal places. It apparently applies the format but it is too late by then. The resultant cells are :

$0.2300 $0.2300
$0.2300 $0.2300

[BigBas]

Try reversing the order, and see if that helps:

EDIT: That didn't work.

[shg]

Interesting.

Change the source formatting from Accounting to General and it works fine.

Or do this:

Please Login or Register  to view this content.

[Richard Schollar]

That's a genuinely freaky occurrence that seems (in my very limited testing) to be restricted to Currency formats. I got around it with:

Please Login or Register  to view this content.

Richard

EDIT: obviously not just CCY formats if Shg's getting it with Accouting...