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