Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell displays formula and not result
A part of my spreadsheet will only display the formula, not the result. I can
oddly change the format by: 1. Re-fomat cell C12 to be "general" format 2. Then click off that cell to another cell. 3. Go back to cell c12 and double click on the cell. 4. Hit "enter" When I set up a trace for the above, this did show that the formula includes the ' or " preceding the = sign, but I cannot work out how to change this through excel. Appreciate any ideas. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell displays formula and not result
Select the cells with the "bad" formulas, then:
<Data <TextToColumns <Finish And your formulas should now work. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "BP" wrote in message ... A part of my spreadsheet will only display the formula, not the result. I can oddly change the format by: 1. Re-fomat cell C12 to be "general" format 2. Then click off that cell to another cell. 3. Go back to cell c12 and double click on the cell. 4. Hit "enter" When I set up a trace for the above, this did show that the formula includes the ' or " preceding the = sign, but I cannot work out how to change this through excel. Appreciate any ideas. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell displays formula and not result
Worked a treat .... thanks
"ragdyer" wrote: Select the cells with the "bad" formulas, then: <Data <TextToColumns <Finish And your formulas should now work. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "BP" wrote in message ... A part of my spreadsheet will only display the formula, not the result. I can oddly change the format by: 1. Re-fomat cell C12 to be "general" format 2. Then click off that cell to another cell. 3. Go back to cell c12 and double click on the cell. 4. Hit "enter" When I set up a trace for the above, this did show that the formula includes the ' or " preceding the = sign, but I cannot work out how to change this through excel. Appreciate any ideas. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell displays formula and not result
You're welcome, and appreciate the feed-back.
-- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "BP" wrote in message ... Worked a treat .... thanks "ragdyer" wrote: Select the cells with the "bad" formulas, then: <Data <TextToColumns <Finish And your formulas should now work. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "BP" wrote in message ... A part of my spreadsheet will only display the formula, not the result. I can oddly change the format by: 1. Re-fomat cell C12 to be "general" format 2. Then click off that cell to another cell. 3. Go back to cell c12 and double click on the cell. 4. Hit "enter" When I set up a trace for the above, this did show that the formula includes the ' or " preceding the = sign, but I cannot work out how to change this through excel. Appreciate any ideas. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|