Thread: CONCATENATE
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
How to get commas in the #'s of concaten How to get commas in the #'s of concaten is offline
external usenet poster
 
Posts: 1
Default CONCATENATE

I have the following cells
A1: D Roberts
B1: 56
C1: MAT
D1: 16,608.80

I need the sentance to read:
D Roberts 56 days $16,608.80 MAT

My formula is =CONCATENATE('Delinquent Loan 30 days'!A3," ",'Delinquent
Loan 30 days'!B3," days ","$",'Delinquent Loan 30 days'!D3, "
",'Delinquent Loan 30 days'!C3)

I am getting:
D Roberts 56 days $16608.8 MAT

How do I get my numbers to have the commas in them?