The weighted average maturity, or WAM, of one of these securities is the average number of months until the loans are paid off. A higher WAM means that you can expect to receive payments for a longer period of time than a lower WAM indicates.
No worries. Itâs easy to change it back. To change from the R1C1 cell reference style back to to the A1 style, we will change a setting in the options. Click the âFileâ tab. On the backstage screen, click âOptionsâ in the list of items on the left.On the âExcel Optionsâ dialog box, click âFormulasâ in the list of items on the left.In the âWorking with formulasâ section, select the âR1C1 reference styleâ check box so there is NO check mark in the box. Click âOKâ to accept the change and close the âExcel Optionsâ dialog box.n the backstage screen, click âOptionsâ in the list of items on the left. On the âExcel Optionsâ dialog box, click âFormulasâ in the list of items on the left. In the âWorking with formulasâ section, select the âR1C1 reference styleâ check box so there is NO check mark in the box.
Change data types in Design view. If you have the table open in Datasheet view, right-click the document tab for the table and click Design View. -or-. If you do not have the table open, in the Navigation Pane, right-click the table that you want to change, and then click Design View on the shortcut menu.Locate the field that you want to change, and select a new data type from the list in the Data Type column. Save your changes.hange data types in Datasheet view. In the Navigation Pane, locate and double-click the table that you want to change. Access opens the table in Datasheet view. Select the field (the column) that you want to change.