Thread: Need to copy the RESULT of a format

Hi,

I'm relatively new to VBA in Excel and I've got an issue where that I need to copy the RESULT of a format, and use it in my calculations. Another way to phrase this would be that I need to make the format apply to the underlying data, not just change how it is displayed.

Is there an easy way to do this? Or am I going to have to write another macro to compute this value?

Thanks in advance!
Charles