Take out the ceros of specific cells, not the whole worksheet
Closed
jutulu
Posts
34
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 21, 2015
-
Mar 11, 2014 at 05:20 PM
jutulu Posts 34 Registration date Monday March 10, 2014 Status Member Last seen September 21, 2015 - Mar 11, 2014 at 06:08 PM
jutulu Posts 34 Registration date Monday March 10, 2014 Status Member Last seen September 21, 2015 - Mar 11, 2014 at 06:08 PM
Related:
- Take out the ceros of specific cells, not the whole worksheet
- Transfer data from one excel worksheet to another automatically - Guide
- How would you change all cells containing the word pass to green - Excel Forum
- Excel if range of cells contains specific text then return value ✓ - Excel Forum
- How do you add a username or author to a worksheet - Guide
- Clear only the formatting from the selected cell (leaving the content) - Guide
2 responses
xpcman
Posts
19530
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,826
Mar 11, 2014 at 05:29 PM
Mar 11, 2014 at 05:29 PM
I would think you right click on the cell and select format.
jutulu
Posts
34
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 21, 2015
2
Mar 11, 2014 at 06:08 PM
Mar 11, 2014 at 06:08 PM
Yes, understand that. You go to format and choose number. But I need some columns to show the ceros when empty, so I when to options and ticked "show zeros", which make zero cells as a default. But I would like to know how to actually make the cero appear as a default, or not to appear only in specific cells. Sorry if the question is not very clear
