invert values in a column

Hi Alex,

Select the cells containing the values to be inverted, then press command-C to copy.

Click the Table button and choose a table style for a new auxiliary table.

Reduce the new table to two columns (Neither should be a header column, although I left one header row on my example below.)

Click on cell A2 of the new table, then press command-V to paste.

Click on cell B2, press = to open the Formula Editor, and enter the formula shown below the table in the image above.

A2*-1

Note that you must enter the multiplication operator ( * ), which Numbers will immediately change to the multiplication sign ( × ).

Fill the formula down as many rows as necessary.

Copy the cells in column B.

Select (aingle click) the cell containing the first value to be converted in the Main table, then

Go to th Edit menu and choose Paste Formula Results.

Clear column A of the Invert table, and set it aside for the next set of values to convert,

Regards,

Barry

If the numeric data in the CSV is of the form $1.00 and -$1.00 you can do two find/replaces in TextEdit to swap all plusses to minuses and vice versa.

Find/Replace $ with -$

Find/Replace -- with nothing.

@**

Ahh...

It took a second look to spot that tiny space between the two - signs in the second run!

Well done!

Regards,

Barry

No space, just the two minus signs. But the find/replace method does require something to key on, like a currency symbol.

This 'tiny space,' not a 'space' character. ;-)

Ahh, the impreciseness of the English language.