FormattedValue Property
Indicates the formatted display of a cell value.
Return Values
Returns a String and is read-only.
Remarks
Use the FormattedValue property to obtain the formatted display value of the Value property of a Cell object. For example, if the value of a cell was 1056.87, and this value represented a dollar amount, FormattedValue would be $1,056.87.