|
Sum Value using ALT+ENTER
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 |
Sum Value using ALT+ENTER
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 |
Sum Value using ALT+ENTER
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 |
Sum Value using ALT+ENTER
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 |
| All times are GMT +1. The time now is 04:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com