How to remove formula in a cell and have only values ??

Originally posted by : CA Abhishek Singh
	Hello everyone, i had prepared profit U& loss a/c, capital a/c and b/s of my client in excel. by mistake i pressed some button that i do not know and due to this wherever i have used formula in there instead of value/amt. formula is appearing. for. eg. for example instead of 6 "sum=4+2" is displayed. i want that cell shoudl show only value i.e.6.

Press ctrl-~ (leftside button from #1 ) to show\hide formula whithin cells.

P.S. BTW if you liked any exshail utility, be a fan on my face book page .... https://www.facebook.com/pages/Exshail-Classic-Menu-for-Excel-2007/180222532014621.
 

Press ctrl + '~'  to show / hide formula whithin cells.

Your excel sheet is in formula audit mode now., you can verify the formula now.

Ctrl+~  to activate formula audit

again press Ctrl+~ to remove formula audit mode.

Hi,

Just copy the formula cell and again in the same cell click right button of mouse and select paste special and again select values radio button and press OK. then u can see the value without formula and no change in value also.

i think ur doubt is cleared.

sudhakar 09347522600

Press ctrl + '~'  to show / hide formula whithin cells.

U have wrongly pressed the ctrl+~ button. To deactivate the formulae mode plz press the same again. You will get normal window.