How do I show a value instead of formula in excel?



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

Post New Answer

More MS Excel Microsoft Interview Questions

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?

1 Answers  


How do I compare lists in excel?

1 Answers  


How do you split cells in excel 2016?

1 Answers  


How do I split a cell into two rows in excel?

1 Answers  


What is range in excel?

1 Answers  


How do you take a percentage off a number in excel?

1 Answers  


How do you create an index in excel?

1 Answers  


What is the filter function in excel?

1 Answers  


What is the formula to calculate density?

1 Answers  


How could you insert a new row between rows 20 and 21?

1 Answers  


What does consolidate mean in excel?

1 Answers  


Where is auto format excel 2016?

1 Answers  


Categories