WAEC - Data Processing (2015 - No. 17)

The spreadsheet symbol used to convert a number to a label is
quotation mark (“ “)
equality sign (=)
underscore (_)
apostrophe sign (')

Explanation

An apostrophe before a cell value forces Excel to interpret the value as label. This is mostly useful for values that look like a number or date.

Comments (0)

Advertisement