Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ria
 
Posts: n/a
Default cell reference show cell name (ie. D45) and not cell value

my boss and i have randomly tested this problem.
in one cell you type =A23. of course we are expecting a value but instead it
resulted in A23.

what's interesting is that if you copy a cell that does give you the value,
this cell where you're having problems will be fine and return a value.

please advise how to resolve this problem or if it is a bug and there's just
an available workaround.

thanks.
  #2   Report Post  
CyberPhix
 
Posts: n/a
Default

The formatting of the cell is set to TEXT, Make it General


-----Original Message-----
my boss and i have randomly tested this problem.
in one cell you type =A23. of course we are expecting a

value but instead it
resulted in A23.

what's interesting is that if you copy a cell that does

give you the value,
this cell where you're having problems will be fine and

return a value.

please advise how to resolve this problem or if it is a

bug and there's just
an available workaround.

thanks.
.

  #3   Report Post  
RagDyer
 
Posts: n/a
Default

*Just* changing the format will *not* solve the problem!

*After* the format is changed, then the formula must be re-entered.
This *does not* mean that you must re-type the formula.
Select the cell, hit <F2, then <Enter, and the formula will then
calculate.

If you have a few cells, you can change the format and re-enter the formula
with these keystrokes:

Select all the "bad" cells, then:
<Ctrl <Shift <~ once (shortcut to format to "General"),
Then <F2 <Enter for each cell selected.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"CyberPhix" wrote in message
...
The formatting of the cell is set to TEXT, Make it General


-----Original Message-----
my boss and i have randomly tested this problem.
in one cell you type =A23. of course we are expecting a

value but instead it
resulted in A23.

what's interesting is that if you copy a cell that does

give you the value,
this cell where you're having problems will be fine and

return a value.

please advise how to resolve this problem or if it is a

bug and there's just
an available workaround.

thanks.
.


  #4   Report Post  
Myrna Larson
 
Posts: n/a
Default

If they are formulas, you can do it a bit easier, I think:
To change the format: Edit/Clear/Formats

Then
Edit/Replace
Find What equal sign
Replace With equal sign


On Thu, 4 Nov 2004 15:02:22 -0800, "RagDyer" wrote:

*Just* changing the format will *not* solve the problem!

*After* the format is changed, then the formula must be re-entered.
This *does not* mean that you must re-type the formula.
Select the cell, hit <F2, then <Enter, and the formula will then
calculate.

If you have a few cells, you can change the format and re-enter the formula
with these keystrokes:

Select all the "bad" cells, then:
<Ctrl <Shift <~ once (shortcut to format to "General"),
Then <F2 <Enter for each cell selected.


  #5   Report Post  
RagDyer
 
Posts: n/a
Default

That <Edit <Clear <Formats
is a new one on me!<bg
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"Myrna Larson" wrote in message
...
If they are formulas, you can do it a bit easier, I think:
To change the format: Edit/Clear/Formats

Then
Edit/Replace
Find What equal sign
Replace With equal sign


On Thu, 4 Nov 2004 15:02:22 -0800, "RagDyer" wrote:

*Just* changing the format will *not* solve the problem!

*After* the format is changed, then the formula must be re-entered.
This *does not* mean that you must re-type the formula.
Select the cell, hit <F2, then <Enter, and the formula will then
calculate.

If you have a few cells, you can change the format and re-enter the formula
with these keystrokes:

Select all the "bad" cells, then:
<Ctrl <Shift <~ once (shortcut to format to "General"),
Then <F2 <Enter for each cell selected.


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



All times are GMT +1. The time now is 10:54 PM.

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"