View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default Custom format rounding

On Mon, 13 Feb 2006 15:00:12 -0800, "Ray88"
wrote:

How can I display 123,432,000 as 123,400 using custom formats? What I need is
rounding to the nearest 100,000.


As far as I know, you can only use custom formats to display rounding to the
nearest 10^x where mod(x,3) = 0


--ron