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.

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.
>

=A1&" "&TEXT(B1,"#,##0.00") returns bob 425.00


Gord Dibben MS Excel MVP


On Thu, 19 Jun 2008 10:56:03 -0700, rrupp <(E-Mail Removed)>
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.