Returning Data
Overview
You must choose the property or method to return data that returns the data and formatting characteristics that you need, as explained in the following sections, and in detail in each of the property and method topics in the reference guides.
You can return either formatted or unformatted data from a specified cell or block of cells. The format and the data type of the returned data depend on the cell type of the cells for which you are returning data and the method or property you use to return the data.
Returning formatted data returns the formatting characters or information with the numeric value, such as monetary symbols, as in the value $1,234.56. Returning the same value as an unformatted value returns the numeric value 1234.56, with no dollar sign and no separator character. For more information about formatted versus unformatted data, see Formatted and Unformatted Data.