Thread: Combining Date and Amount
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Combining Date and Amount
Hi,

Try this

=TEXT(A46,"DD/MM/YYYY")&" "&TEXT(B46,"£000.00")

Mike

"stew" wrote:

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