Need to copy the RESULT of a format

[csgroce]

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

[DonkeyOte]

You can use the text value of a cell in VBA

Range("A2").Value = Range("A1").Text

so say for ex. A1 contains the value 2 but has a custom format applied to it of: "S"000

such that it appears as S002, the above would set A2 to be S002 rather than 2.