FORMULA NOT SHOWING VALUE
Hi
I have used the concatenate formula, and it is coreect, however the only thing displaying in the cell is the formula and not the value, what do i do to make the value display? Cheers -- Nenagh |
FORMULA NOT SHOWING VALUE
Does this occur with all formulas?
Perhaps you are in Formula View. Hit CTRL + `(backquote above Tab key) OR The cell was pre-formatted as Text. Format to General then hit F2 then ENTER to re-enter the formula. Gord Dibben MS Excel MVP On Sun, 27 May 2007 16:44:01 -0700, Nenagh wrote: Hi I have used the concatenate formula, and it is coreect, however the only thing displaying in the cell is the formula and not the value, what do i do to make the value display? Cheers |
All times are GMT +1. The time now is 04:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com