ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Force zeros in Excel 2007 when cells blank and keep commas for thousands (https://www.excelbanter.com/excel-discussion-misc-queries/446454-force-zeros-excel-2007-when-cells-blank-keep-commas-thousands.html)

Tony O[_3_]

Force zeros in Excel 2007 when cells blank and keep commas for thousands
 
I am using Excel 2007 for my spreadsheet.

When I clear out the cells for the sales part, I want it to force
zeros as values. When the sales are in the cells, I want to display
with the comma format. For example 12345 should show up as 12,345

I'm thinking I need to push the custom format with #,##0
and something additional to force the zeros, but I don't know what to
do additionally.

Please advise.


All times are GMT +1. The time now is 10:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com