Thread: calculated fields - change field settings
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stan Brown Stan Brown is offline
external usenet poster
  
Posts: 524
Default calculated fields - change field settings
Tue, 10 Jul 2007 23:18:04 -0700 from FaN404 <FaN404
@discussions.microsoft.com:

on a calculated field I've just created, the SUM settings appears by default.
As I wish to calculate AVERAGE, how can I change from SUM to AVERAGE?

Click in the cell, press F2, and type the change.

Maybe I misunderstood your question?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
Reply With QuoteReply With Quote