In Excel, a number is made into a label by typing an apostrophe (') before the number. For example, entering '123 will treat the entry as text rather than a numerical value. This is useful when you want to display a number without it being used in calculations.
The symbol "#" is typed before a number or label.
The symbol used before a number to make it a label is a hash sign (#).
-
Write an apostrophe ( ' ) in the cell, before the number.
A label is usually text or it could be a number in a text format, such as having a year as a heading. For text it is typed in normally, and for numbers we put the single quote before it, so Excel does not treat it as being a number.
Put a single quote before the number or type it in as usual and format it as Text. The number will align to the left, which indicates that it is text. Using the single quote is simpler, like this: '64
In Microsoft Excel, a label prefix is a character that can be added before a label (text entry) to indicate specific formatting or to differentiate it from numerical data. Common label prefixes include apostrophes (') to denote text or equal signs (=) to indicate a formula. Prefixes help Excel interpret the data correctly and ensure that the intended format is maintained during calculations or data analysis.
text in a cell
The chemical symbol for carbon on a medicine label is "C".
alpha
The periodic label for sulfur is S, which is its chemical symbol.
label