| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate cells with text and numbers/decimals
I have a column with letters and another column with numbers with decimals
that I have concatenated. But, the zero's after the decimal drop off. For example. Column A Bob Column B 452.00 If the numeral is a decimal with anything other than zero, it comes across but above, it shows as Bob452, I need the decimal so Bob452.00 Any suggestions? I searched the site but couldn't find what I needed. Thanks for your time. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatenate cells with text and numbers/decimals
Covert the number to text and then add the two values together
"rrupp" wrote: I have a column with letters and another column with numbers with decimals that I have concatenated. But, the zero's after the decimal drop off. For example. Column A Bob Column B 452.00 If the numeral is a decimal with anything other than zero, it comes across but above, it shows as Bob452, I need the decimal so Bob452.00 Any suggestions? I searched the site but couldn't find what I needed. Thanks for your time. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatenate cells with text and numbers/decimals
=A1&" "&TEXT(B1,"#,##0.00") returns bob 425.00
Gord Dibben MS Excel MVP On Thu, 19 Jun 2008 10:56:03 -0700, rrupp wrote: I have a column with letters and another column with numbers with decimals that I have concatenated. But, the zero's after the decimal drop off. For example. Column A Bob Column B 452.00 If the numeral is a decimal with anything other than zero, it comes across but above, it shows as Bob452, I need the decimal so Bob452.00 Any suggestions? I searched the site but couldn't find what I needed. Thanks for your time. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate large numbers of cells | Excel Discussion (Misc queries) | |||
| VBA to concatenate Text and/or Numbers and/or dates etc | Excel Discussion (Misc queries) | |||
| Concatenate Text & Numbers Keeping zeros.. | Excel Worksheet Functions | |||
| How do I merge 2 cells to 1 when contents are numbers AND retain decimals | Excel Discussion (Misc queries) | |||
| Concatenate text and numbers? | Excel Worksheet Functions | |||
Linear Mode
