hide $ sign when formula is zero

[bobalee01]

Hi! I'm using Mac OS 16.16.
I'm working on a spread sheet with formulas and when the fields the formula link to are blank I want the formula field to be empty, No Dollar signs shown. Not every line will have values in them. If their is a zero in the field I would like those not to show a dollar sign too but I can not find a way to hide zero either. Any help is greatly appreciated.
thanks

 

[DRSteele]

Welcome to the forum.

Use a custom number format. This is the appropriate code: $#,##0_);$(#,##0);""

The first section is for the positive number format, then a semi-colon to separate the sections, then the negative number format; then a semi-colon, then the zero number format. For you the zero number format will be left blank after the semi-colon or can be two quotes, meaning null-format.

Here is an interesting website where you can tinker with all the formats without having to drive around in that little dialog box in Excel.

 

[kevin9999]

I'm not sure about a Mac, but the following Custom Number Format in a Windows/365 environment does work. Worth a try?

$* #,##0.00;$* (#,##0.00);""

Book1
	A	B	C
1	$ 100.00	$ 59.00	$ 41.00
2
3
4		$ 3.00	$ (3.00)
5
6
Sheet1

Cell Formulas
Range	Formula
A2:A6	A2	=1-1
C6	C6	=5-5