Excel Question. Why is the formula being shows instead of the computed value?

you've set the cell to text only format, which will show everything you've typed just as you type it. Right click the cell and select format, change it to "general".

Excel Cell Shows Formula

This Site Might Help You.

RE:

Excel Question. Why is the formula being shows instead of the computed value?

Usually if you have a formula in a cell, you would see the computed value there and the function on the function bar on the top right? For me, only in this particular spreadsheet, it shows formula in both places. How do I make it show the value in the cell?

Don't forget the equal sign at the beginning of the equation.

you ddnt specify the language that you wanted the program in. Edit: English language?? i meant computer language for instance in fortran in the following program d represents the distance >>><<< PROGRAM distance REAL:: y1, y2, x1, x2, d PRINT*,"enter the first x coordinate" READ*, x1 PRINT*,"enter the first y coordinate " READ*,y1 PRINT*,"enter the second x coordinate" READ*, x2 PRINT*,"enter the second y coordinate " READ*,y2 d=sqrt(((x2-x1)**2)+(y2-y1)**2) PRINT*," the distance between the points is", d END PROGRAM distance

go to tools , options, under window options unclick formulas.