Sum Text

[jkktx81]

I have 2 questions; I have done these same things several times before but can't get to work this time.

1: Trying to have formula that will show what text is another cell and it keep showing up as a 0 instread of the text that is in that cell.

2: Trying to sum data from another workbook. I thought before I have been able to click the cell in destination workbook, then switch to source WB and click it, then when when I switch back to destination WB it would show that formula, but not happening.

Any help appreciated...

 

[Robert Mika]

Q1

Excel 2010
	A	B	C
1	Numbers as text	Number	Number
2	22222	22222	22222
3	FALSE	TRUE	TRUE
Sheet1

Cell Formulas
Range	Formula
B2	=A2+0
B3	=ISNUMBER(B2)
C2	=VALUE(A2)
C3	=ISNUMBER(C2)
A3	=ISNUMBER(A2)

Q2:
Can you give more details.
What's happening when you are switching back to destination workbook?
Are you opening the another workbook from withing the first one?
(File-->Open...

 

[jkktx81]

Thanks Robert on the ISNUMBER help.

I will work on the other question later today and reply back after trying to get that to work.

But yes I was working with 2 different workbooks and both open. Trting to pull data from cells of the other workbook.

 

[jkktx81]

I am trying to pull the data from the other open workbook.

It does fine until I get to where there is text in the cell and it will not show the text only displays 0.

I have tried using conditional formatting and entering =ISNUMBER(C8).

Here is the formula result that would not work.
=SUM('[Load Track 2012 Master rev 05-2012.xls]APR'!$X$8)

 

[Robert Mika]

CF does not change to text to Value.
As I see you trying to SUM one cell only?

You can try like this:
Excel 2010<table rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB" cellpadding="2.5px"><colgroup><col style="background-color: #DAE7F5" width="25px"><col><col></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th>
</th><th>A</th><th>B</th></tr></thead><tbody><tr><td style="color: #161120;text-align: center;">1</td><td style="text-align: right;;">8</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">
</td><td style="text-align: right;;">8</td></tr></tbody></table>

Sheet3​

<table rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" cellpadding="2.5px" width="85%"><tbody><tr><td style="padding:6px">Worksheet Formulas<table rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB" cellpadding="2.5px" width="100%"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th style=" background-color: #DAE7F5;color: #161120" width="10px">B2</th><td style="text-align:left">=SUM(VALUE(A1))</td></tr></tbody></table></td></tr></tbody></table>


But this is quite akward way of using SUM for one cell only
You can change that to

Excel 2010<table rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB" cellpadding="2.5px"><colgroup><col style="background-color: #DAE7F5" width="25px"><col><col></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th>
</th><th>A</th><th>B</th></tr></thead><tbody><tr><td style="color: #161120;text-align: center;">1</td><td style="text-align: right;;">8</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">
</td><td style="text-align: right;;">8</td></tr></tbody></table>

Sheet3​

<table rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" cellpadding="2.5px" width="85%"><tbody><tr><td style="padding:6px">Worksheet Formulas<table rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB" cellpadding="2.5px" width="100%"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th style=" background-color: #DAE7F5;color: #161120" width="10px">B2</th><td style="text-align:left">=VALUE(A1)</td></tr></tbody></table></td></tr></tbody></table>


Which give the same result