Sets the default format for saved files and other compatibility options. This makes it easier to share Excel workbooks with Windows users or users of other spreadsheet programs.
serial_number,return_type!Returns a number from 1 to 7 identifying the day of the week of a date.!is a number that represents ...
serial_number,return_type!Returns the week number in the year!is the date-time code used by Microsoft Excel for date and ...
Sets options for how your Excel data will look when the data is viewed in a web browser. Affects: only the active workbook. ...
Sets the Custom Lists available. Click a list that you want to edit, or click NEW LIST in the Custom Lists box to create ...
Sets the default format for saved files and other compatibility options. This makes it easier to share Excel workbooks with ...
Sets the maximum amount of change below which iteration stops for goal seeking or for resolving circular references based ...
Sets the maximum number of iterations used for goal seeking or for resolving circular references based on the number you ...
Sets the preferred file type Excel uses when you save workbooks. If your workbooks are used in different versions of Excel, ...
settlement,maturity,coupon,yld,frequency,basis!Returns the annual duration of a security with periodic interest payments!is ...