| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenate results without decimals
I have two results which I want to concatenate in another cell.
I do not want to have decimals with - does anybody know how to avoid this ? My example is: A1=23 (cell format set to 0 decimals) A2=4 (cell format set to 0 decimals) In formula line for B2 I set: =A1&"±"&A2 Then cell B2 shows 23,333333±4,122343 but I like it shows 23±4 Can somebody help? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Concatenate results without decimals
You could round the value
=round(A1,0)&"±"&round(A2,0) -- Kevin Smith :o) "kemp" wrote: I have two results which I want to concatenate in another cell. I do not want to have decimals with - does anybody know how to avoid this ? My example is: A1=23 (cell format set to 0 decimals) A2=4 (cell format set to 0 decimals) In formula line for B2 I set: =A1&"±"&A2 Then cell B2 shows 23,333333±4,122343 but I like it shows 23±4 Can somebody help? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Concatenate results without decimals
Dear Kevin,
Great - thank you very much for helping. "Kevin Smith" skrev: You could round the value =round(A1,0)&"±"&round(A2,0) -- Kevin Smith :o) "kemp" wrote: I have two results which I want to concatenate in another cell. I do not want to have decimals with - does anybody know how to avoid this ? My example is: A1=23 (cell format set to 0 decimals) A2=4 (cell format set to 0 decimals) In formula line for B2 I set: =A1&"±"&A2 Then cell B2 shows 23,333333±4,122343 but I like it shows 23±4 Can somebody help? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Concatenate results without decimals
Kemp, if you dont want to Round the numbers in those cells use
=TRUNC(A1)&"±"&TRUNC(A2) If this post helps click Yes --------------- Jacob Skaria "kemp" wrote: I have two results which I want to concatenate in another cell. I do not want to have decimals with - does anybody know how to avoid this ? My example is: A1=23 (cell format set to 0 decimals) A2=4 (cell format set to 0 decimals) In formula line for B2 I set: =A1&"±"&A2 Then cell B2 shows 23,333333±4,122343 but I like it shows 23±4 Can somebody help? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Concatenate results without decimals
Another solution:
=TEXT(A1,"0")&"±"&TEXT(A2,"0") Regards, Stefi kemp ezt *rta: I have two results which I want to concatenate in another cell. I do not want to have decimals with - does anybody know how to avoid this ? My example is: A1=23 (cell format set to 0 decimals) A2=4 (cell format set to 0 decimals) In formula line for B2 I set: =A1&"±"&A2 Then cell B2 shows 23,333333±4,122343 but I like it shows 23±4 Can somebody help? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Concatenate results without decimals
You might as well save yourself 3 characters...
=TEXT(A1,"0±")&TEXT(A2,"0") -- Rick (MVP - Excel) "Stefi" wrote in message ... Another solution: =TEXT(A1,"0")&"±"&TEXT(A2,"0") Regards, Stefi kemp ezt *rta: I have two results which I want to concatenate in another cell. I do not want to have decimals with - does anybody know how to avoid this ? My example is: A1=23 (cell format set to 0 decimals) A2=4 (cell format set to 0 decimals) In formula line for B2 I set: =A1&"±"&A2 Then cell B2 shows 23,333333±4,122343 but I like it shows 23±4 Can somebody help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate Displays Too Many Decimals | Excel Discussion (Misc queries) | |||
| CONCATENATE not producing any results | Excel Worksheet Functions | |||
| Concatenate cells with text and numbers/decimals | Excel Worksheet Functions | |||
| format decimals displayed based on results | Excel Discussion (Misc queries) | |||
| Rounding results to nearest quarter (in decimals) | Excel Discussion (Misc queries) | |||
Hybrid Mode
