Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
i need to concatenate numbers and text but don't want the numbers to lose
formatting. For example this is what I want a single cell to say: The minimum = 22,309.09; the maximum = 36,999.30; the standard deviation = 5,559.59 Where the numbers and text will all be concantenated separately b/c the min, max, and stdev are coming from separate columns. I can get these all together using concatenate but then the numbers lose their commas. Does anyone have advice? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extract Numerics only | Excel Discussion (Misc queries) | |||
Ignore text but not numerics on SUM() function | Excel Worksheet Functions | |||
QUERRY ONLY RETURNING NUMERICS | Excel Discussion (Misc queries) | |||
How to forecast non-numerics? | Excel Worksheet Functions | |||
Formula with text and numerics | Excel Worksheet Functions |