Question

What is the use of putting an apostrophe before a number value?

Answer 1

Explanation:

An apostrophe before a cell value forces Excel to interpret the value as text. This is mostly useful for values that look like a number or date. For example, Dec-1 would ordinarily be converted to a date in December.