I want to sum two value but result shows add with + Sign. Example
Student ID Fee Student ID Sum
1 100 1 400 (calculate sum but when goes to cell show like +100+300)
2 200 2 700 (+200+200+300)
1 300 3
3 200 4
4 100
2 200
2 300
Printable View
I want to sum two value but result shows add with + Sign. Example
Student ID Fee Student ID Sum
1 100 1 400 (calculate sum but when goes to cell show like +100+300)
2 200 2 700 (+200+200+300)
1 300 3
3 200 4
4 100
2 200
2 300
I want to sum two value but result shows add with + Sign. Example
Student ID Fee Student ID Sum
1 100 1 400 (calculate sum but when goes to cell show like +100+300)
2 200 2 700 (+200+200+300)
1 300 3
3 200 4
4 100
2 200
2 300
it's not clear for me, attach a sample file with more comments
Hi
You can toggle the formula view by cliking Ctrl + `
In MS excel 2007, you can go to select the Home button and select Excel Options>> Go to Advanced, under "Display options for this worksheet" u can select "Show Formulas in cells instead of their calculated results. This would show you the formula instead of the value.
Do you mean you want to show the result of the sum in the cell, but the formula in the cell should not contain an equal (=) sign at the beginning?
Attched Sample File