# Formatted versus Unformatted Data

Learn the difference between formatted and unformatted data in Spread Windows Forms. Understand how the Text and Value properties work in handling data for various cell types.

## Content



The Spread Windows Forms component provides both text (formatted data) and value (unformatted data) properties for a cell. For example, in a currency cell, the formatted data could be $1,432.56, but the value would be 1432.56. The Text property of the cell would return the entire formatted string with currency symbol and thousand separator. The Value property of the cell could be used in formulas or other calculations. Every cell has both properties. Depending on the cell type, the data in a cell may be handled differently. For cell types that have buttons or check boxes, the distinction is important.

For more detailed information on the difference between formatted and unformatted data, and a summary of the results for specific cell types, refer to [Handling Data Using Sheet Methods](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-usedata/spwin-dataaddreturn/spwin-databymethod).

## See Also

[Product Overview](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-concepts/spwin-oviewproduct)

[Shortcut Objects](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-concepts/spwin-oviewproduct/spwin-knowobjshorts)

[Underlying Models](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-concepts/spwin-oviewproduct/spwin-knowobjmodels)

[Cell Types](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-concepts/spwin-oviewproduct/spwin-knowcelltypes)