| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FORMULA SHOWING AS #### | Excel Worksheet Functions | |||
| Formula Showing Zero instead of nothing | Excel Discussion (Misc queries) | |||
| Sum Formula Showing Instead of Value :( | Excel Discussion (Misc queries) | |||
| Showing/ not showing "getting started" when excel starts | Excel Discussion (Misc queries) | |||
| Formula result not showing in cell | Excel Worksheet Functions | |||
Linear Mode
