Thread: Number Format?
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gb_S49 gb_S49 is offline
external usenet poster
 
Posts: 23
Default Number Format?

Perfect
Many Thanks
:-)


"gb_S49" wrote:

I have entered the following in cell A1 ="Average "&AVERAGE(D:D)
and the value I get is Average 47.247619047619.
How can I round down to 1 decimal place?
I have tried number format but it does not make a difference
:-(