why do some of my total cells show $ - but not all of them?
G Gord Dibben Aug 16, 2006 #3 The ones that show $ - are formatted as Accounting and contain a value of zero. Gord Dibben MS Excel MVP
The ones that show $ - are formatted as Accounting and contain a value of zero. Gord Dibben MS Excel MVP
M Max Aug 16, 2006 #4 Nancy said: why do some of my total cells show $ - but not all of them? Click to expand... 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)
Nancy said: why do some of my total cells show $ - but not all of them? Click to expand... 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)
