Excell hiding zero's

Resolved · High Priority · Version Standard

Thu 5 Feb 2009, 13:17 Delegate jane said...

jane has attended:
Excel Intermediate course

Excell hiding zero's

how do i hide the zero's in a document

Thu 19 Mar 2009, 11:26 Trainer Rajeev said...

RE: excell hiding zero's

Dear Jane

Thank you for attending Excel Intermediate course!! I hope you enjoyed the course and benefited from it.

Please choose Tools > Options...

In the View Tab under the Window options section untick Zero Values.

Press OK

All your zeros will be hidden!!

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Excel tip:

Add Text to Displayed Numbers in Excel 2010

To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text!

View all Excel hints and tips

Excell hiding zero's

Excell hiding zero's

RE: excell hiding zero's

Excel articles

Excel tip:

Add Text to Displayed Numbers in Excel 2010