"Nancy" wrote:
why do some of my total cells show $ - but not all of them?

Assuming the same "Accounting" format is applied, then those that show: $ -
contain zeros (inputs or formula returns), while those that don't are either
empty cells or cells containing: "" (zero length null strings returned by
formulas)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---