When entering numbers in a cell, Excel does not let you format a single cell to view the cell contents without that cell being active. All you see is the result.
I have a a worksheet with 50 rows and in cell “A1” through “A50”, I sometimes apply factors to a number.
Example: Cell A1 =50*1.1
Cell A2 =8*2*8/36
In cell “B1” I would like to have this formula come over as text so when I print the worksheet, I can check to see if I have applied the right factors.
Example Output Cell B1 50*1.1
Cell B2 8*2*8/36
Is there an Excel function that lets me do this.
I am using Excel 2000
