VBA formatting for cell values containing Zero

[kdickerson]

Hello All,

I am currently working on a project for work that enables the user to populate a report using data from multiple tabs. I had originally set the entire field formatting to #,### (as seen below). However now, when I make a cell equal to zero it remains blank in the report. Does anyone have any suggestions as to how to show zeros in a cell if the value is zero?


With Range("C11:AP50")
.NumberFormat = "#,###"
End With

Thank you in advance!

 

[MARK858]

Possibly

.NumberFormat = "#,###;-#,###;0"

 

[kdickerson]

I figured it out, but for future reference if any one runs into this problem simply change the last # sign to a zero i.e., .NumberFormat - "#,##0


With Range("C11:AP50")
.NumberFormat = "#,###"
End With

 

[kdickerson]

Thanks Mark! I just made the change to #,##0.