Thread: Combining Date and Amount
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Combining Date and Amount
=TEXT(A46,"dd mmm yyyy")&" and "&TEXT(B46,"£0.00")
Adjust the formatting parameters and text to suit.
--
David Biddulph

"stew" wrote in message
...
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


Reply With QuoteReply With Quote