Question

Explain number format and text format using examples

Answer 1

Answer:

Number formats are used to control the display of cell values that contain numeric data. This numeric data can include things like dates, times, costs, percentages, and anything else expressed as a number. ... To apply a number format, just select one or more cells and choose a format.

Formatted text is text that is displayed in a special, specified style. ... Text formatting data may be qualitative (e.g., font family), or quantitative (e.g., font size, or color). It may also indicate a style of emphasis (e.g., boldface, or italics), or a style of notation (e.g., strikethrough, or superscript).