The Text() function does change the returned data to text, which the Sum()
function will *not* total.
That can be easily remedied by simply adding a double unary to the front of
the function, like so:
=--TEXT(A1,"#,###,,")
However, this does *not* return exactly what you're asking for.
If applied to 1,515,500,455
the return would be 1,516
Which is not simply truncating the number.
Since you're starting with real numbers, try this:
=INT(A1/1000000)
Then just format the column to insert the commas.
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
ooooohhhh - I didn't catch that - I see now.
No - I don't want to retain the original number - I just want the number
after it's truncated.
One thing I noticed is that the TEXT funcition aligns the number to the left
of the cell instead of the right. Will that affect summing, etc?