Custom Format cell to leave blank (need help adjusting current formula)

[muad'ebe]

I am currently using this formula in the custom format of the cell -

0.00;-0.00;;@,

This gives numerical results in the cell in this format - 0000.00

I would like to adjust the formula to add the comma as the thousands separator when necessary to produce this format - 0,000.00 (when over a thousand) 000.00 when less than a thousand.

I tried this 0,000.00;-0,000.00;;@, but it puts the comma in the cell even when the number value is less than a thousand ( ,253.00)

The reason for the custom format is that I am pulling numbers from sheets that don't always exist (Sheets are added as necessary) and I want the cell to remain blank when there is no value being pulled in from the non-existing sheet.

I admit I don't fully understand how to get the custom format right. Any help is greatly appreciated!

 

[JamesCanale]

Use:
#,##0.00

 

[Fluff]

How about

#,##0.00;-#,##0.00;;@,

 

[muad'ebe]

Thank you both for your replies. This one from Fluff worked perfectly -

#,##0.00;-#,##0.00;;@,

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[muad'ebe]

Glad we could help & thanks for the feedback.

I'm wondering if there's a way to modify this formatting so that when the number is ZERO (or no entry) that there would be an empty cell rather than the comma which currently populates the cell when the value is zero.

Using this format - #,##0.00;-#,##0.00;;@, (Would like blank cell for zero, currently it leaves just the comma ",")

 

[Fluff]

There is a stray comma at the end, remove it.