In some cases, a formula or number that is entered into a cell needs to be retained in its original form. For example, display zero characters when entering the number 00056 or specify a function without its further use. To do this, the cell with the number or function should be formatted as Text.
The formatting is applied by using a single quotation mark ('). The single quotation mark should be entered in a cell immediately before the function or number to be recognized as text. For example, '=SUM(B1;C1) or '00056.
The quotation mark is displayed:
–In the formula bar, when you select a cell.
–In the cell and in the formula bar, when you edit a cell.
If you want to cancel text formatting, delete the quotation mark in the cell.