View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rrupp rrupp is offline
external usenet poster
 
Posts: 22
Default 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.