Formulas

sapapd

New Member
Joined
Dec 2, 2009
Messages
5
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.
 
Last edited:

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,734
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
-
 

Watch MrExcel Video

Forum statistics

Threads
1,122,569
Messages
5,596,915
Members
414,110
Latest member
docops

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top