PPRuNe Forums - View Single Post - Yet another Excel question..
View Single Post
Old 27th Dec 2007, 20:33
  #5 (permalink)  
Keef

Official PPRuNe Chaplain
 
Join Date: Apr 2001
Location: Witnesham, Suffolk
Age: 80
Posts: 3,498
Likes: 0
Received 0 Likes on 0 Posts
If you just want fields with zero value not to display £0.00, all you need to do is to set up the "field format" accordingly.

Click on the range of cells where you want to do this,
Click Format - Cells - Number - Custom
Click in the box where it says "Type ... General"
Enter £ #,##0.00 ;£(#,##0.00);

That's pound space # comma # # 0 point 0 0 space semicolon pound bracket # comma # # 0 point 0 0 bracket semicolon space


£123.45 will display as £ 123.45 space
-£123.45 as £(123.45)
£0.00 as
Keef is offline