Concatenate cells with text and numbers/decimals

R

rrupp

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge - displaying a conditional number of decimals 5
Trim varying decimals from column of numbers 9
How to center adjust text above and image in a two column document. 1
concatenate problem 8
Formatting and adding cells formatted to 2 decimal places 3
Problem with SET & REF function 0
Conditional Formatting from a group 6
Addition errors with Decimal Places 6

Top