Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I must have clicked the wrong thing
Formulas which used to calculate, then disappear leaving only the answer, now
remain without showing the answer. If I replace = with =, it works but only in that case. How can I get back to normal? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I must have clicked the wrong thing
It sounds like the cells are formatted as TEXT.
Change the format to GENERAL. Then, select the cell and either double click or hit function key F2 then hit Enter. If you have a bunch of cells to convert... Select all the cells in question Change the cell format to GENERAL With the cells still selected Goto the menu EditReplace Find what: = (equal sign) Replace with: = (equal sign) Replace All -- Biff Microsoft Excel MVP "Lake Oswego" wrote in message ... Formulas which used to calculate, then disappear leaving only the answer, now remain without showing the answer. If I replace = with =, it works but only in that case. How can I get back to normal? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I must have clicked the wrong thing
Excellent work! I did convert that column to text because I was getting
desperate about my Match not working and was trying everything. I have found several people who have experienced two cells that look and smell the same but Match won't treat them as the same. We have to be talking about some hidden formatting that causes Exact to see a difference when we don't. "T. Valko" wrote: It sounds like the cells are formatted as TEXT. Change the format to GENERAL. Then, select the cell and either double click or hit function key F2 then hit Enter. If you have a bunch of cells to convert... Select all the cells in question Change the cell format to GENERAL With the cells still selected Goto the menu EditReplace Find what: = (equal sign) Replace with: = (equal sign) Replace All -- Biff Microsoft Excel MVP "Lake Oswego" wrote in message ... Formulas which used to calculate, then disappear leaving only the answer, now remain without showing the answer. If I replace = with =, it works but only in that case. How can I get back to normal? . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I must have clicked the wrong thing
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I must have clicked the wrong thing
An Example about cahracters looking same but being different:
A < Α The first one is ordinary A (ASCII code 65) The second one is different (unicode character with code 913) Arvi Laanemets |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I must have clicked the wrong thing
The problem could also because by internal rounding error. There may be a
tiny fraction of a decimal not being seen, and so 0<0, or so it may appear. Here's an example: In A1 type the formula =64.4 - 64 in B1 simply type in .4 in C1 put the formula =IF(A1=B1,"Equal","Not Equal") The result will be "Not Equal" because the calculation 64.4-64 actually returned 0.400000000000006 ! If this seems to be the problem, you can try ROUND() or even change the Excel Options to "Precision as Displayed", just be cautious with that last one. "Lake Oswego" wrote: Excellent work! I did convert that column to text because I was getting desperate about my Match not working and was trying everything. I have found several people who have experienced two cells that look and smell the same but Match won't treat them as the same. We have to be talking about some hidden formatting that causes Exact to see a difference when we don't. "T. Valko" wrote: It sounds like the cells are formatted as TEXT. Change the format to GENERAL. Then, select the cell and either double click or hit function key F2 then hit Enter. If you have a bunch of cells to convert... Select all the cells in question Change the cell format to GENERAL With the cells still selected Goto the menu EditReplace Find what: = (equal sign) Replace with: = (equal sign) Replace All -- Biff Microsoft Excel MVP "Lake Oswego" wrote in message ... Formulas which used to calculate, then disappear leaving only the answer, now remain without showing the answer. If I replace = with =, it works but only in that case. How can I get back to normal? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
not sure if i'm using the right thing | Excel Worksheet Functions | |||
Oh, just one more thing | Excel Discussion (Misc queries) | |||
Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
One Last Thing | Excel Discussion (Misc queries) | |||
one more thing | Excel Worksheet Functions |