Formatting Numbers question

[thp510]

Hello. I'm formatting my numbers that will show both positive and negative numbers. Here's the format that I'm using: "$"#,##0,0;

When it's positive, it shows up pretty well (i.e. $150,300) and when it's negative, it's blank as intended. However when the number is $0.00, I have the following show up: $00

Unfortunately, that's not what I want and would rather have it show up as blank (just like the negative number). At the minimum, maybe just $0 instead of the two zeros. Can someone help me with the proper custom number formatting? Btw, I'm using Google Sheets if that matters.

Thanks,
Tom

 

[KevCarter]

In Excel you would write $#,##0;;

Note the second semi-colon.

I'm not sure if it's the same in Google Sheets.

 

[thp510]

Brilliant. Thank you, that worked.

 

[KevCarter]

Good deal. Have a great night!

 

[Joackley]

i need help in formatting my cell to make my location numbers look like this A06.F24.T and i cannot seem to get it to format right

 

[Fluff]

Please start a thread of your own for this question.
When doing so you will need to supply a lot more detail.
Thanks