I don't think there is a "format" that will do what you want, but I would
guess VB could help out... however, we would need to know a little more
about your requirements. Are we talking only about addition (and I assume
subtraction)? What about multiplication, division and raising to powers?
Could any function calls be involved (MOD, SIN, and the like)? I would think
the more of these that are involved, the lengthier the code would be to
handle them all.

--
Rick (MVP - Excel)


"Steven" wrote in message
...
Sometimes I run into the problem of a cell with many items in it. For
example:
=6546456.23+6548985.89+7892598.25+12548868.32

The cell show the total but if someone is reading the numbers it makes it
a
more difficult that they are not formatedd with commas.

Is there a way to help this visual?

Thank you,

Steven