Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excell hiding zero's
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excell hiding zero's
Resolved · High Priority · Version Standard
Reply Thu 5 Feb 2009, 13:17Delegate jane said...
jane has attended:
Excel Intermediate course
Excell hiding zero's
how do i hide the zero's in a document
For upcoming training course dates see: Pricing & availability
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
|