Text Property Example

This example sets a variable for the formatted value of cell A1.

txt = Spreadsheet1.Range("a1").Text