| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text & formual problem combined
When I combine text and a formula - i.e. ="Avg "& SUM(D30) - it comes out as
Avg 0.286253661284266 but I only want it to 2 decimal points! The D30 cell contains the simple formula for £152458.70 divided by 532,600 Can someone explain or show me how I can produce an answer to 2 decimal points as "Avg 0.28"? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text in a combined spreadsheet | Excel Discussion (Misc queries) | |||
| Formual error with text and calc | Excel Discussion (Misc queries) | |||
| Figures and text combined | Excel Worksheet Functions | |||
| text and number combined in a cell | Excel Worksheet Functions | |||
| text and values combined in one cel | Excel Discussion (Misc queries) | |||
Threaded Mode
