Copied Values Truncating

[GeneralShamu]

I am unsure why but when I am copying cells/numerical values from a sheet into an array only 4 decimalp points are being stored.

I define the 2d array as a Variant.

E.g. 36.920465851
is stored as
36.9204 (or possibly 36.9205)

I am unsure if it is being rounded as well as it is quite difficult to find these errors and I have simply noticed it by stumbling upon it.

Any ideas?

 

[shg]

Could you post the code you use to put the values in the array?

Also, how are the cells on the worksheet formatted -- in particular, are the formatted as currency?

 

[GeneralShamu]

Could you post the code you use to put the values in the array?

Also, how are the cells on the worksheet formatted -- in particular, are the formatted as currency?

Formatted as currency; can't post code unfortunately.

I do something like:
x = Cell(...)
ThisWorkbook.Worksheets(...).Cells(...) = x

where x is a String even though the value going into x is a curreny.

[[[I do a lot of string comparisons on the data.]]]

 

[shg]

The default property of Range is Value, and the Value property converts values formatted as currency to data type Currency, which is a scaled integer with precision = $0.0001.

So use the Value2 property of the cells.

 

[GeneralShamu]

The default property of Range is Value, and the Value property converts values formatted as currency to data type Currency, which is a scaled integer with precision = $0.0001.

So use the Value2 property of the cells.

Ahh very intriguing.

We have decided to simply truncate the values to 4 decimal places though.

I will definitely keep this in mind going forward.

Thank you shg

 

[shg]

You're welcome, but the conversion to Currency rounds, not truncates.

 

[GeneralShamu]

You're welcome, but the conversion to Currency rounds, not truncates.

Good to know; still does not matter for us since we average these values over 10 - 1000 data rows.

 

[shg]

If you're averaging, it's better.