Thread: Don't want 0.00
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Barrett9699 Barrett9699 is offline
external usenet poster
 
Posts: 1
Default Don't want 0.00


Yeah, select cell H22, go Format Cells... click Number tab... Catagory:
custom... Type:

#.##; -#.##; ""

Click OK.

Give that a try.


--
Barrett9699
------------------------------------------------------------------------
Barrett9699's Profile: http://www.excelforum.com/member.php...o&userid=37573
View this thread: http://www.excelforum.com/showthread...hreadid=573298