View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default NumberFormat for small non-zero numbers?

Hi,

Am Mon, 26 Nov 2012 09:30:41 -0800 (PST) schrieb
:

Is there anything I can do to make these fall into the zero format as well? I could round it, but is there an easier way?


no, you have to use ROUND


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2