In To How 0 Excel
Notes: the hidden values appear simplest within the formula bar — or inside the cellular in case you edit in the cell — and are not revealed. to display hidden values once more, select the cells, after which press ctrl+1, or on the house tab, inside the cells institution, point to layout, and click on format cells. within the category listing, click widespread to use the default number layout. to redisplay a date or a time, select the. 1. pick out the statistics variety that you want to exchange the zeroes to dashes, proper click, and select format cells from the 2. inside the format cells conversation container, below variety tab, click custom from the class listing, and input zero;-zero;—;@ into the 3. after which click adequate, all zeroes had been replaced by way of. Visit the house tab > variety organization, and pick textual content inside the quantity format container. as quickly as you type a zero(s) before number, excel will display a small green triangle in the top-left c...