TimN Wrote:
If in cell A1 I have "The total as of March 1st was"
And in cell D1 I have a numerical formaula that shows March's total,
say
$1,438.14877.

If I do a formula in cell A1 and say = & D1
I get the result of .... The Total as of March 1st was 1438.14877

How can I get this to show ..... The Total as of March 1st was $1,438
In other words format the number so it has $ and coma and no decimal
places?

Thanks!
Hi TimN,

Try this

=A1&" $"&LEFT(LEFT(D1,5)*1,1)*1&","&RIGHT(LEFT(D1,5)*1,3 )*1

oldchippy :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=570918