Formulas

[sapapd]

I have a spreadsheet were I copy one column over twice, with the same information. The cells contain numbers with a general format. I want to be able to eliminate the zeros from two of the columns, eliminate the negative numbers from one, and positive numbers from one. I found out how to get rid of the zeros but when I format it to currency, the pop back.

 

[sijpie]

OK,

take the first column where you want only positive numbers displayed.

highlight it and then goto the menu: Format - Cells, select Custom

now edit the entry there to read:

$ ##0;-

Do the same thing for the negative column, but there you enter:

$ -;##0

now your positive numbers in column one will look like
$ 50
$ 5
-
$ 32

and your negative column will look like
-
-
$ 23
-