| 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? |
| 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) | |||
Threaded Mode
