Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display formula instead of its values in some cells
Hello all,
I encountered problem for some excel files when typing a formula but displayed a formula instead of its calculated values, e.g. when I entered "=100 + 100", what I exepected is to display as "200", but it was displayed as "=100 + 100" instead. Please kindly help, many thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display formula instead of its values in some cells
It seems like that cell is formatted as Text....
Try this: FormatCellsNumber tab Category: Number Click [OK] Select the cell, press [F2] then press [Enter] Does that help? *********** Regards, Ron XL2002, WinXP-Pro "ah 3" wrote: Hello all, I encountered problem for some excel files when typing a formula but displayed a formula instead of its calculated values, e.g. when I entered "=100 + 100", what I exepected is to display as "200", but it was displayed as "=100 + 100" instead. Please kindly help, many thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display formula instead of its values in some cells
ah 3 wrote: Hello all, I encountered problem for some excel files when typing a formula but displayed a formula instead of its calculated values, e.g. when I entered "=100 + 100", what I exepected is to display as "200", but it was displayed as "=100 + 100" instead. Please kindly help, many thanks! Remove the double quotes around the formula. Thus like this: =100 + 100 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display formula instead of its values in some cells
thanks but can't make test now coz files are in my office, will try and let
you know. "Ron Coderre" ... It seems like that cell is formatted as Text.... Try this: FormatCellsNumber tab Category: Number Click [OK] Select the cell, press [F2] then press [Enter] Does that help? *********** Regards, Ron XL2002, WinXP-Pro "ah 3" wrote: Hello all, I encountered problem for some excel files when typing a formula but displayed a formula instead of its calculated values, e.g. when I entered "=100 + 100", what I exepected is to display as "200", but it was displayed as "=100 + 100" instead. Please kindly help, many thanks! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display formula instead of its values in some cells
Sorry, of course, I haven't typed double quotes in the cells. Thanks
anyway. "Aladin Akyurek" .. . ah 3 wrote: Hello all, I encountered problem for some excel files when typing a formula but displayed a formula instead of its calculated values, e.g. when I entered "=100 + 100", what I exepected is to display as "200", but it was displayed as "=100 + 100" instead. Please kindly help, many thanks! Remove the double quotes around the formula. Thus like this: =100 + 100 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display formula instead of its values in some cells
Check ToolsOptionsView and make sure that Formulas is not checked.
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "ah 3" wrote in message ... Hello all, I encountered problem for some excel files when typing a formula but displayed a formula instead of its calculated values, e.g. when I entered "=100 + 100", what I exepected is to display as "200", but it was displayed as "=100 + 100" instead. Please kindly help, many thanks! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display formula instead of its values in some cells
yes, but I am sure this is not the cause of the problem. Thanks.
"Bob Phillips" bl... Check ToolsOptionsView and make sure that Formulas is not checked. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "ah 3" wrote in message ... Hello all, I encountered problem for some excel files when typing a formula but displayed a formula instead of its calculated values, e.g. when I entered "=100 + 100", what I exepected is to display as "200", but it was displayed as "=100 + 100" instead. Please kindly help, many thanks! |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display formula instead of its values in some cells
Maybe the workbook is becoming corrupt?
Anyway you can select all formulas and do editreplace and replace the equal sign with the equal sign to trigger a calculation before you do that make sure all formats are not text since if you format a cell as text you will see the formula and not the result -- Regards, Peo Sjoblom "ah 3" wrote in message ... yes, but I am sure this is not the cause of the problem. Thanks. "Bob Phillips" bl... Check ToolsOptionsView and make sure that Formulas is not checked. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "ah 3" wrote in message ... Hello all, I encountered problem for some excel files when typing a formula but displayed a formula instead of its calculated values, e.g. when I entered "=100 + 100", what I exepected is to display as "200", but it was displayed as "=100 + 100" instead. Please kindly help, many thanks! |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display formula instead of its values in some cells
its tested good, thanks.
"Ron Coderre" ... It seems like that cell is formatted as Text.... Try this: FormatCellsNumber tab Category: Number Click [OK] Select the cell, press [F2] then press [Enter] Does that help? *********** Regards, Ron XL2002, WinXP-Pro "ah 3" wrote: Hello all, I encountered problem for some excel files when typing a formula but displayed a formula instead of its calculated values, e.g. when I entered "=100 + 100", what I exepected is to display as "200", but it was displayed as "=100 + 100" instead. Please kindly help, many thanks! |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display formula instead of its values in some cells
Ron Coderre has given the answer and tested good. Thanks anyway.
"Peo Sjoblom" l... Maybe the workbook is becoming corrupt? Anyway you can select all formulas and do editreplace and replace the equal sign with the equal sign to trigger a calculation before you do that make sure all formats are not text since if you format a cell as text you will see the formula and not the result -- Regards, Peo Sjoblom "ah 3" wrote in message ... yes, but I am sure this is not the cause of the problem. Thanks. "Bob Phillips" bl... Check ToolsOptionsView and make sure that Formulas is not checked. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "ah 3" wrote in message ... Hello all, I encountered problem for some excel files when typing a formula but displayed a formula instead of its calculated values, e.g. when I entered "=100 + 100", what I exepected is to display as "200", but it was displayed as "=100 + 100" instead. Please kindly help, many thanks! |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display formula instead of its values in some cells
So if you had 200 cells that were like that you would go through each of
them? My method will do it in one fell swoop -- Regards, Peo Sjoblom "ah 3" wrote in message ... Ron Coderre has given the answer and tested good. Thanks anyway. "Peo Sjoblom" l... Maybe the workbook is becoming corrupt? Anyway you can select all formulas and do editreplace and replace the equal sign with the equal sign to trigger a calculation before you do that make sure all formats are not text since if you format a cell as text you will see the formula and not the result -- Regards, Peo Sjoblom "ah 3" wrote in message ... yes, but I am sure this is not the cause of the problem. Thanks. "Bob Phillips" bl... Check ToolsOptionsView and make sure that Formulas is not checked. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "ah 3" wrote in message ... Hello all, I encountered problem for some excel files when typing a formula but displayed a formula instead of its calculated values, e.g. when I entered "=100 + 100", what I exepected is to display as "200", but it was displayed as "=100 + 100" instead. Please kindly help, many thanks! |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display formula instead of its values in some cells
sorry, I haven't study your solution, will try later.
but for Ron's solution, I can also edit one cell and paste to the rest of the same row/column of cells. Thanks. "Peo Sjoblom" .gbl... So if you had 200 cells that were like that you would go through each of them? My method will do it in one fell swoop -- Regards, Peo Sjoblom "ah 3" wrote in message ... Ron Coderre has given the answer and tested good. Thanks anyway. "Peo Sjoblom" l... Maybe the workbook is becoming corrupt? Anyway you can select all formulas and do editreplace and replace the equal sign with the equal sign to trigger a calculation before you do that make sure all formats are not text since if you format a cell as text you will see the formula and not the result -- Regards, Peo Sjoblom "ah 3" wrote in message ... yes, but I am sure this is not the cause of the problem. Thanks. "Bob Phillips" bl... Check ToolsOptionsView and make sure that Formulas is not checked. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "ah 3" wrote in message ... Hello all, I encountered problem for some excel files when typing a formula but displayed a formula instead of its calculated values, e.g. when I entered "=100 + 100", what I exepected is to display as "200", but it was displayed as "=100 + 100" instead. Please kindly help, many thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
display zero values in selected cells | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
If formula that looks at multiple cells and values, and then calul | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |