Home 
Search 
Today's Posts 
#1




Cell doesn't show formula result  it shows formula (CTRL + ' doe.
Cell doesn't show formula result  it shows formula (CTRL + ' doesn't change
it), looks like it happens only when formula is entered manually. If I copy and paste cell with formula  works fine, if I change the cell location whitin formula (i.e. =Schedule!F6 change to =Schedule!H6)  it won't show result, just the formula. I have Office XP, Win XP pro SP2 (all updated), and I also tried reinstalling Office  worked fine for a while and then started doing the same thing. Any help would be greatly appreciated 
#2




check the cell format and make sure it is not formated as
text. Original Message Cell doesn't show formula result  it shows formula (CTRL + ' doesn't change it), looks like it happens only when formula is entered manually. If I copy and paste cell with formula  works fine, if I change the cell location whitin formula (i.e. =Schedule!F6 change to =Schedule! H6)  it won't show result, just the formula. I have Office XP, Win XP pro SP2 (all updated), and I also tried reinstalling Office  worked fine for a while and then started doing the same thing. Any help would be greatly appreciated . 
#3




I end up with that all the time! The best thing to do is format the
column/row/cell as "General". " wrote: check the cell format and make sure it is not formated as text. Original Message Cell doesn't show formula result  it shows formula (CTRL + ' doesn't change it), looks like it happens only when formula is entered manually. If I copy and paste cell with formula  works fine, if I change the cell location whitin formula (i.e. =Schedule!F6 change to =Schedule! H6)  it won't show result, just the formula. I have Office XP, Win XP pro SP2 (all updated), and I also tried reinstalling Office  worked fine for a while and then started doing the same thing. Any help would be greatly appreciated . 
#4




Already tried
" wrote: check the cell format and make sure it is not formated as text. Original Message Cell doesn't show formula result  it shows formula (CTRL + ' doesn't change it), looks like it happens only when formula is entered manually. If I copy and paste cell with formula  works fine, if I change the cell location whitin formula (i.e. =Schedule!F6 change to =Schedule! H6)  it won't show result, just the formula. I have Office XP, Win XP pro SP2 (all updated), and I also tried reinstalling Office  worked fine for a while and then started doing the same thing. Any help would be greatly appreciated . 
#5




Changing the format from text to general is not sufficient.
You must now reenter the formula(s) F2 then <ENTER If you have great many of these, do an EditReplace What: = With: = Replace all. Gord Dibben Excel MVP On Wed, 17 Nov 2004 13:37:27 0800, oo00oo wrote: Already tried " wrote: check the cell format and make sure it is not formated as text. Original Message Cell doesn't show formula result  it shows formula (CTRL + ' doesn't change it), looks like it happens only when formula is entered manually. If I copy and paste cell with formula  works fine, if I change the cell location whitin formula (i.e. =Schedule!F6 change to =Schedule! H6)  it won't show result, just the formula. I have Office XP, Win XP pro SP2 (all updated), and I also tried reinstalling Office  worked fine for a while and then started doing the same thing. Any help would be greatly appreciated . 
#6




Tried that also, but I just restarted computer and it works fine (even though
i also tried this several times). Thanks for your time, i'll just wait and see what happens next. "Gord Dibben" wrote: Changing the format from text to general is not sufficient. You must now reenter the formula(s) F2 then <ENTER If you have great many of these, do an EditReplace What: = With: = Replace all. Gord Dibben Excel MVP On Wed, 17 Nov 2004 13:37:27 0800, oo00oo wrote: Already tried " wrote: check the cell format and make sure it is not formated as text. Original Message Cell doesn't show formula result  it shows formula (CTRL + ' doesn't change it), looks like it happens only when formula is entered manually. If I copy and paste cell with formula  works fine, if I change the cell location whitin formula (i.e. =Schedule!F6 change to =Schedule! H6)  it won't show result, just the formula. I have Office XP, Win XP pro SP2 (all updated), and I also tried reinstalling Office  worked fine for a while and then started doing the same thing. Any help would be greatly appreciated . 
#7




Your advice works, thank you very much.
"Kyli" wrote: I end up with that all the time! The best thing to do is format the column/row/cell as "General". " wrote: check the cell format and make sure it is not formated as text. Original Message Cell doesn't show formula result  it shows formula (CTRL + ' doesn't change it), looks like it happens only when formula is entered manually. If I copy and paste cell with formula  works fine, if I change the cell location whitin formula (i.e. =Schedule!F6 change to =Schedule! H6)  it won't show result, just the formula. I have Office XP, Win XP pro SP2 (all updated), and I also tried reinstalling Office  worked fine for a while and then started doing the same thing. Any help would be greatly appreciated . 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
inserting data from a row to a cell, when the row number is specified by a formula in a cell  New Users to Excel  
Amount or Numbers in Words  New Users to Excel  
I want the results of a formula to show in cell, NOT THE FORMULA!  Excel Discussion (Misc queries)  
Why does the formula result show a number but the screen shows ze.  Excel Worksheet Functions  
Excel 2003  Formula result shows as 0:00  Excel Worksheet Functions 