What a great tip Roger, it saves all the complicated formual entries (which
are great) and I can just SUM each cell now which is easier and quicker than
typing the long formula.

Thanks for sharing.

AW

"Roger Govier" wrote:

An another option

FormatCellsNumberCustom "Total: " #,##0.00
In cell just use
=SUM(A1:A20)

--
Regards

Roger Govier


"Dana DeLouis" wrote in message
...
Just another option. Note the double quote.

=TEXT(SUM(A1:A20),"""Total:"" #,##0.00")

--
HTH :)
Dana DeLouis
Windows XP & Office 2003


"Carter68" wrote in message
...
Is there a way I can enter text and a formula in a cell. For
example: I
want to have the word "Total" and the count of the column in a cell.