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
|