CELLSTR Function

The CELLSTR function returns the formatted contents of a cell number as a string into the current cell.

Syntax

CELLSTR(<cell number>)

A cell number must be specified and it returns the formatted contents number of that cell, as a string. This reference must be a direct cell reference.

Example 1

Enter CELLSTR(c1) where c1 is a number cell, with a value of 1000 formatted to display as $(1,000)

Returns the string $(1,000). If not using CELLSTR function, the value returned would have been 1000 – the absolute value of the cell.

CELLSTR works with any specially formatted cells, such as date cells.

Related Topics