ExcelBanter - Cell shows only formula, no result

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Cell shows only formula, no result (https://www.excelbanter.com/excel-worksheet-functions/32738-cell-shows-only-formula-no-result.html)

alexrm

Cell shows only formula, no result

I have run into this a few times and forgot how I solved it before. I
am doing a simple vlookup in Excel 2003 and instead of giving me a
formula result the cell just retains the text of the formula. What
option or fomatting do I need to change?

--
alexrm

Jim Thomlinson

Change the format of the cell to Numeric or ... Select the Cell. Hit F2 and
then Enter...
--
HTH...

Jim Thomlinson

"alexrm" wrote:

I have run into this a few times and forgot how I solved it before. I
am doing a simple vlookup in Excel 2003 and instead of giving me a
formula result the cell just retains the text of the formula. What
option or fomatting do I need to change?

--
alexrm

All times are GMT +1. The time now is 03:09 AM.