kdickerson
New Member
- Joined
- Jun 21, 2015
- Messages
- 4
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!
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!