text and number combined in a cell

[TimN]

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!

[Trevor Shuttleworth]

="The total as of March 1st was " & TEXT(D1,"$0")

Regards

Trevor


"TimN" <[email protected]> wrote in message
news:[email protected]...
> 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!

[Bearacade]

=a1 & " " & Dollar(d1,0)

or if you are putting this in A1, ="The total as of March 1st was " & Dollar(d1,0)

You don't want to use text because the comas won't show.

[oldchippy]

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

[Trevor Shuttleworth]

Or maybe better:

="The total as of March 1st was " & TEXT(D1,"£#,##0")

Regards

Trevor


"Trevor Shuttleworth" <[email protected]> wrote in message
news:[email protected]...
> ="The total as of March 1st was " & TEXT(D1,"$0")
>
> Regards
>
> Trevor
>
>
> "TimN" <[email protected]> wrote in message
> news:[email protected]...
>> 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!
>
>