Cell.DisplayText Property

A CellValue object specifies a piece of data contained in a cell - cell value. It is accessed via the CellRange.Value property. A cell can contain data of the numeric, text, Boolean or error type. You can apply different number formats to display a cell's numeric data in the appropriate view. For example, a numeric value can be displayed as a decimal number, a percentage, currency value, etc. Also, a number contained in a cell can be formatted as a date and time value (see the Dates and Times in Cells document for details). The DisplayText property returns the string that specifies how the formatted value is displayed in the cell.

The Cell.IsDisplayedAsDateTime property indicates whether the cell value is formatted as date and time.