Combining Date and Amount

S

stew

Hi all

In A46 I have Date. In B46 I have Cash amount £460.99
IN C46 I WOULD LIKE TO HAVE DATE AND £460.99
iS THIS POSSIBLE?

STEW
 
D

David Biddulph

=TEXT(A46,"dd mmm yyyy")&" and "&TEXT(B46,"£0.00")
Adjust the formatting parameters and text to suit.
 
Top