Mac Numbers -- make negative numbers positive and vice versa

Easy enough to do with a duplicate of the Table with this formula in every cell of 'Table 1"

= Table 1::A1*-1

Where 'A1' represents a cell on the card statement containing a number, and the formula is in A1 of your table.

Credit card accounts record and calculate the amount you currently owe. When you charge a purchase to that card account, the charge increases the amount you owe. When you make a payment to the account, that payment reduces the amount you owe.

Regards,

Barry

Hi Janet,

Placing an image on these posts requires taking an screed shot of the part of the screen you want to show, saving that screenshot to your Desktop, then inserting it into your post by clicking the icon with two mountains in the row below the composing       ☟       window.

To take a screen shot of a table or part of a table:

Select a cell on the table to activate the table and display the row and columns reference tabs above and left of the table.

Place the pointer at the top left corner of the area you want to include in the screen shot.

Press shift-command-4 to set the system to screen shot mode.

The pointer will change from an arrow to a crosshairs.

Press the mouse button and drag the crosshairs down and to the right to create a selection rectangle that contains the part of the screen you want to capture.

Release the mouse button to capture the area within the rectangle.

You'll hear a 'click' reminiscent of an SLR camera as the shot is taken and saved to your Desktop with the name "Screen shot," followed by the date and time at which it was taken.

Clicking the mountain scenery icon should take you directly to your Desktop folder, where you can double-click the file to insert the image at the insertion point in your post.

Regarding your description:

• the table has 6 header columns, A through F

Unless Apple has changed the Header Columns specifications in the current version, there can be no more than five header columns in a table. This limit also applies to Header Rows and Footer rows. Select the table and check the Table menu for an update to these numbers:

The numbers beyond 1 in the example are greyed as the selected table has only 2 columns.

I'm guessing the table into which the CSV file has been pasted has six columns, one of which may be a header column, and several rows, one, or possibly two of which are Header Rows.

Labels for the six columns, placed in header row cells in the appropriate column, are likely:

Date, Transaction, Description, Debit, Credit, Balance.

I see two approaches to converting the table to the format you want:

1. Duplicate the existing table. Leave the first three columns of the duplicate (containing no numerical data that needs to be changed) as they are.

• • Delete the numerical content of columns D, E and F. Leave the labels in the header row(s) as they were.
  • Select the first non-header cell in column D (for the example, I'm using D3)
  • type =to open the formula editor on this cell. Enter the formula below:

IF(Bank::D3="","",Bank::D3*-1)

• • (Where the formula says "Bank::D3, click on the first non-header cell in column D of the original table. Numbers will insert the table name and cell address.)
  • Click the green checkmark to confirm the formula and closr the editor.

As written, the formula assumes ALL cells in column D are either empty or contains a number. If this is not so, we'll need to revise the formula to handle non-numerical values other than 'empty'.

• • With the formula in D3 showing the correct result (either 'empty' or the reversed value in the same cell of the original table) AND with the cell still selected, press command-C to copy the cell and it's formula.
  • With the cell still selected. scroll to the bottom row of the table.
  • Press and hold the shift key, and click on the last cell in column F to add that cell, and all cells between it and D3 to the selection.
  • Release the shift key, then, with the cells of columns D to F still selected, press command-V to paste the formula into all selected cells.
  • Click away from the table (on an empty space not on either table) to deselect all cells.

Visually inspect the second table to ensure that all data has been transferred and switched from positive to negative or vice versa.

• • To make a non-volatile version of the second table:
  • Select all cells in columns D, E and F.
  • Press command -C to Copy
  • Go to the Edit menu and choose Paste formula results.

This paste replaces the formulas with the last value calculated by those formulas, which removes the dependence of cells on this table from values on the original.

Regards,

Barry