Hi,

I have a macro that copies numeric data from one spreadsheet to a variable. My problem is that when a number format hides trailing decimals, the entire number is copied, instead of the displayed number. For example, the actual number is 181.456789, but it's displayed as 181.457. I want to copy the 181.457 only (ignoring the remaining digits). Is there a way to do with this (without reading in the Range.NumberFormat property and reapplying it?).

Also, the number formats are dynamic, so I can't use the round or truncate functions. Ideally I'm looking for something like a Range.FormattedValue property (which probably doesn't exist).

Thanks,
Chris