View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default show $ in blank cells

The ones that show $ - are formatted as Accounting and contain a value of
zero.


Gord Dibben MS Excel MVP

On Tue, 15 Aug 2006 18:36:02 -0700, Nancy
wrote:

why do some of my total cells show $ - but not all of them?