Adding Text, Date and Numbers together in a formula
 

Hi

Basically i have a list that comprises of the following information

Date Amount
22/10/2008 (in date format) 2556.43835616438 (in number format,specific)

All i want to be able to do is at the end of each row put the following into
the cell
"Paid 22/10/2008 £2,556.44" without having to write it out everytime.

How can i have the word "Paid" with the date in cell A2 and the amount in
cell B2 correct to 2dp.
Thanks.

Adding Text, Date and Numbers together in a formula
 

With date & value in A1 & B1, use:

="Paid " & TEXT(A1,"dd/mm/yyyy") & " £" & TEXT(B1,"#,##0.00")
--
Gary''s Student - gsnu200808


"Bazy2k" wrote:

Hi

Basically i have a list that comprises of the following information

Date Amount
22/10/2008 (in date format) 2556.43835616438 (in number format,specific)

All i want to be able to do is at the end of each row put the following into
the cell
"Paid 22/10/2008 £2,556.44" without having to write it out everytime.

How can i have the word "Paid" with the date in cell A2 and the amount in
cell B2 correct to 2dp.
Thanks.

Adding Text, Date and Numbers together in a formula
 

Worked Beautifully! Thanks Gary.

"Gary''s Student" wrote:

With date & value in A1 & B1, use:

="Paid " & TEXT(A1,"dd/mm/yyyy") & " £" & TEXT(B1,"#,##0.00")
--
Gary''s Student - gsnu200808


"Bazy2k" wrote:

Hi

Basically i have a list that comprises of the following information

Date Amount
22/10/2008 (in date format) 2556.43835616438 (in number format,specific)

All i want to be able to do is at the end of each row put the following into
the cell
"Paid 22/10/2008 £2,556.44" without having to write it out everytime.

How can i have the word "Paid" with the date in cell A2 and the amount in
cell B2 correct to 2dp.
Thanks.