Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Valid formula remains in cell
I used the function arguments dialog to create and verify the function
results in a cell. When I select the OK button, the cell content displays the formula not the results. I cannot seem to locate why. Can anyone tell me why? |
#2
|
|||
|
|||
The cell is probably formatted as Text, format it as General then click in
the formula in the formula bar and hit F2, Regards, Alan. "Wally" wrote in message ... I used the function arguments dialog to create and verify the function results in a cell. When I select the OK button, the cell content displays the formula not the results. I cannot seem to locate why. Can anyone tell me why? |
#3
|
|||
|
|||
Hi Wally,
If the cell is already formatted as General or a number and F2 fixes it then you probably have spaces or Char(160). You could Trim the content of text cells using the TrimALL macro in http://www.mvps.org/dmcritchie/excel/join.htm#trimall Also check to make sure that you have calculation set to automatic. Tools, Options, calculation (tab), calculation: automatic When you change the format from text to number or number to text the number format will not change until you reenter data. The TrimALL macro will make this a lot easier for redoing large areas of cells rather than using F2 then Enter for an individual cell. Use of F2 then Enter will reenter data just the same as if you had typed in new content. If F2 then Enter works it may serve also serve as warning that calculation is not turned on. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Alan" wrote in message ... The cell is probably formatted as Text, format it as General then click in the formula in the formula bar and hit F2, Regards, Alan. "Wally" wrote in message ... I used the function arguments dialog to create and verify the function results in a cell. When I select the OK button, the cell content displays the formula not the results. I cannot seem to locate why. Can anyone tell me why? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
looking for a formula | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |