Take Kevin's advice, NEVER mix numbers that need to be calculated with
text..

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"kilianli" wrote in
message ...

I'm using more line as the record need to have the list inside, i need
to show out different condition inside the cell. so need to use more
need to list out different.
Any suggestion to me that allow me input a list of condition in the row
???
Kevin B Wrote:
The new line character (Alt + Enter) is changing the number to a text
value.
Why don't you just adjust the height of the row. Click FORMAT in the
menu,
select ROW, click HEIGHT and enter the row height value.

You can adjust where the text appears in the larger cell by clicking
FORMAT,
select CELLS and then click on the ALIGNMENT tab. Use the horizontal
and
vertical text alignment options to place the text correctly within the
cell.

--
Kevin Backmann


"kilianli" wrote:


i have enter the record in the row, and inside the cell, i'm using
ALT+Enter to make more line for the record, but i would like to know
how to sum of the value in this cell??
e.g.

C1 C2 C3
R1 1 1 XD
R2 2 2 YY
R3 1 XY
R3 2 A
R4 3 3

how can i get the value of A = 3, that is the sum of R3C1(1+2)
also, how can i put the dollar sign automatically in cell R3C1 if
i'm
using "ALT+ENTER" to make more line.


--
kilianli

------------------------------------------------------------------------
kilianli's Profile:
http://www.excelforum.com/member.php...o&userid=32328
View this thread:
http://www.excelforum.com/showthread...hreadid=521136




--
kilianli
------------------------------------------------------------------------
kilianli's Profile:
http://www.excelforum.com/member.php...o&userid=32328
View this thread: http://www.excelforum.com/showthread...hreadid=521136