ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell Referencing (https://www.excelbanter.com/excel-discussion-misc-queries/3539-cell-referencing.html)

Silver

Cell Referencing
 
I am simply referencing one cell from another.
For example, in cell L55 I am using the formula +C34,
intending to see the value of C34 in L55.

Instead of the value in C34, "+C34" is displayed in L55.
What am I doing wrong?

Thanks for your help,

Silver

KLP

you should put "=c34" to get the correct info

"Silver" wrote:

I am simply referencing one cell from another.
For example, in cell L55 I am using the formula +C34,
intending to see the value of C34 in L55.

Instead of the value in C34, "+C34" is displayed in L55.
What am I doing wrong?

Thanks for your help,

Silver


Jason Morin

L55 may be formatted as text. Try this.

1. Select L55.
2. Press <Ctrl<Shift<~.
3. Press F2.
4. Press <Enter.

HTH
Jason
Atlanta, GA

-----Original Message-----
I am simply referencing one cell from another.
For example, in cell L55 I am using the formula +C34,
intending to see the value of C34 in L55.

Instead of the value in C34, "+C34" is displayed in L55.
What am I doing wrong?

Thanks for your help,

Silver
.



All times are GMT +1. The time now is 05:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com