How do I show a value instead of formula in excel?
Answer / Srishti Gautam
To show a value instead of formula in Excel, right-click on the cell with the formula, choose 'Format Cells', then go to 'Number tab'. Choose 'Custom' and type an equal sign (=) without quotes. Click OK.
| Is This Answer Correct ? | 0 Yes | 0 No |
I have saved my workbook with a password, but excel does not recognize it and would not let me open the file. Am I out of luck?
How do I compare lists in excel?
How do you split cells in excel 2016?
How do I split a cell into two rows in excel?
What is range in excel?
How do you take a percentage off a number in excel?
How do you create an index in excel?
What is the filter function in excel?
What is the formula to calculate density?
How could you insert a new row between rows 20 and 21?
What does consolidate mean in excel?
Where is auto format excel 2016?