Www.qa.com/excel In this video, Chris Harvey, specialist trainer in Excel 2007 and Excel 2010 at QA, shows. Excel 2010 displays the zeros by default, but there are two different ways that someone could get the program to display a blank cell instead -- one that covers.
Www.qa.com/excel In this video, Chris Harvey, specialist trainer in Excel 2007 and Excel 2010 at QA, shows us how to enter a number in Microsoft Excel and retain the leading zeros. Have you ever tried to enter data inn Excel and found that Excel changes it? Perhaps it shortens it, drops decimal places or removes the leading zeros? Very frustrating if you are entering telephone numbers or dates! This video will show how to format cells so that they retain all of the information you need. In addition it shows you how to ignore Excel's green triangle warnings.
For courses on how to use Excel 2003, 2007, 2010 or 2013 more efficiently visit our website at www.qa.com/excel or click on the course links below: Microsoft Excel 2010 Level 1 - Microsoft Excel 2010 Level 2 - Microsoft Excel 2010 Level 3 - For more tutorials and top tips on using Excel 2007 or Excel 2010 see our other videos.