Take out the ceros of specific cells, not the whole worksheet
Closed
jutulu
Posts
34
Registration date
Monday 10 March 2014
Status
Member
Last seen
21 September 2015
-
11 Mar 2014 à 17:20
jutulu Posts 34 Registration date Monday 10 March 2014 Status Member Last seen 21 September 2015 - 11 Mar 2014 à 18:08
jutulu Posts 34 Registration date Monday 10 March 2014 Status Member Last seen 21 September 2015 - 11 Mar 2014 à 18:08
Related:
- Take out the ceros of specific cells, not the whole worksheet
- How do i find a specific video on youtube - Guide
- Excel arrow keys not moving cells - Guide
- You have a workbook with multiple worksheets and want an exact copy of one of the worksheets ✓ - Excel Forum
- Vba add worksheet - Guide
- Transfer data from one excel worksheet to another automatically - Guide
2 responses
xpcman
Posts
19528
Registration date
Wednesday 8 October 2008
Status
Contributor
Last seen
15 June 2019
1,824
11 Mar 2014 à 17:29
11 Mar 2014 à 17:29
I would think you right click on the cell and select format.
jutulu
Posts
34
Registration date
Monday 10 March 2014
Status
Member
Last seen
21 September 2015
2
11 Mar 2014 à 18:08
11 Mar 2014 à 18:08
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
