Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
o0o0o0o
 
Posts: n/a
Default 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   Report Post  
 
Posts: n/a
Default

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   Report Post  
Kyli
 
Posts: n/a
Default

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   Report Post  
oo00oo
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

Changing the format from text to general is not sufficient.

You must now re-enter 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   Report Post  
oo00oo
 
Posts: n/a
Default

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 re-enter 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   Report Post  
dc
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 08:18 AM
Amount or Numbers in Words ron New Users to Excel 6 December 24th 04 08:32 PM
I want the results of a formula to show in cell, NOT THE FORMULA! ocbecky Excel Discussion (Misc queries) 4 December 10th 04 09:39 PM
Why does the formula result show a number but the screen shows ze. Jam-Du Excel Worksheet Functions 2 November 12th 04 10:07 PM
Excel 2003 - Formula result shows as 0:00 Serena Excel Worksheet Functions 4 November 11th 04 11:18 PM


All times are GMT +1. The time now is 06:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"