All worksheet data is stored in cells. Each cell can only hold and display a single piece of data - the cell value.
This example demonstrates how easy it is to programmatically add data of different types to worksheet cells. To do this, assign the required value to the Range.Value property of a cell or range object. Use the properties of the CellValue object returned by the Range.Value property to retrieve information about the cell value type, and get the cell value itself as an object of the corresponding type. To get the string specifying the formatted value as it is displayed in a cell, use the Cell.DisplayText property.