Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying Formula Results in Cell
I have a very strange problem, in certain cells, the formula displays and not
the result. No, I do not have 'display formula' turned as other cells are operating correctly. Here is a very simple example, I am copying the cell data above and the first two cells show the formula and the next the result. If I replace '+B8' with, say, =Proper(B8), I still only see the formula. 703611B NH054837A Radford T Aug-65 Jan-89 703611B NH054837A Radford T Aug-65 Apr-94 +B8 +C8 Radford T 23981 34429 Any help greatly appreciated. Charles |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying Formula Results in Cell
Are those cells formatted as text. Change them to General, then F2 to edit,
and Enter. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "macshimi" wrote in message ... I have a very strange problem, in certain cells, the formula displays and not the result. No, I do not have 'display formula' turned as other cells are operating correctly. Here is a very simple example, I am copying the cell data above and the first two cells show the formula and the next the result. If I replace '+B8' with, say, =Proper(B8), I still only see the formula. 703611B NH054837A Radford T Aug-65 Jan-89 703611B NH054837A Radford T Aug-65 Apr-94 +B8 +C8 Radford T 23981 34429 Any help greatly appreciated. Charles |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying Formula Results in Cell
Hi Charles - it may be the Cell Format got set to Text. Execel is very
helpful and sets the format to what it thinks you entered, but it does get mixed up sometimes. Check the cell and see if it says =+B8. If not then it is has assumed you entered Text rather than an expression and set the Cell format to Text. If it has the =, still make sure the Cell format is set to General or somesuch, not Text. If no =, still check the format, delete and enter again. Hope this helps "macshimi" wrote: I have a very strange problem, in certain cells, the formula displays and not the result. No, I do not have 'display formula' turned as other cells are operating correctly. Here is a very simple example, I am copying the cell data above and the first two cells show the formula and the next the result. If I replace '+B8' with, say, =Proper(B8), I still only see the formula. 703611B NH054837A Radford T Aug-65 Jan-89 703611B NH054837A Radford T Aug-65 Apr-94 +B8 +C8 Radford T 23981 34429 Any help greatly appreciated. Charles |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying Formula Results in Cell
I had checked the format and set it to General. I have got around the problem
by a simple IF statement. Very strange as it only those two columns, the rest are problem free. "Kernow Girl" wrote: Hi Charles - it may be the Cell Format got set to Text. Execel is very helpful and sets the format to what it thinks you entered, but it does get mixed up sometimes. Check the cell and see if it says =+B8. If not then it is has assumed you entered Text rather than an expression and set the Cell format to Text. If it has the =, still make sure the Cell format is set to General or somesuch, not Text. If no =, still check the format, delete and enter again. Hope this helps "macshimi" wrote: I have a very strange problem, in certain cells, the formula displays and not the result. No, I do not have 'display formula' turned as other cells are operating correctly. Here is a very simple example, I am copying the cell data above and the first two cells show the formula and the next the result. If I replace '+B8' with, say, =Proper(B8), I still only see the formula. 703611B NH054837A Radford T Aug-65 Jan-89 703611B NH054837A Radford T Aug-65 Apr-94 +B8 +C8 Radford T 23981 34429 Any help greatly appreciated. Charles |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
no formula results in cell | Excel Worksheet Functions | |||
Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
How do I prevent incorrect formula results appearing in cell? | Excel Worksheet Functions | |||
How do you copy a cell formula down a column without displaying n. | Excel Worksheet Functions |