Combining Date and Amount
 

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

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

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

Combining Date and Amount
 

this would be better

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

Mike

"Mike H" wrote:

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

Combining Date and Amount
 

Does the Job . Thanks Mike

Stew

"Mike H" wrote:

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