In Excel, you cannot combine text and numeric entries in a mathematical expression such as addition or subtraction. Text in calculations In Lotus 1-2-3, cells that contain text are considered to have a value of 0 (zero) when the cell is used in a formula. To calculate according to Lotus 1-2-3 rules, select the Transition formula evaluation option on the Transition tab ( Tools menu, Options command).