View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
The Bookeeper The Bookeeper is offline
external usenet poster
 
Posts: 1
Default Accounting format returns a - for zero other cells show 0.0 Why?

Cell format set to accounting returns a - for zero. The sample box also shows
-.
On other cells with accounting format 0.00 is returned and the sample box
shows 0.00. How can the sample be changed to give me a consistent format?

Many thanks