text and numbers same cell and formulas still work (like lotus)
I am converting a Lotus 1-2-3 spreadsheet to Excel 2003 (SP3). Lotus allows
for text or numbers to be entered into a cell that is referenced in a formula
that calculated a price. If text is entered in the cell it looks as if Lotus
ignores it and the calculation is not executed.
If I try this with Excel, it executes the text and renders an error. Is
there a way to duplicate what Lotus is doing?
|