Back to lesson
1. Requiring the number 0.07 to appear as .070, which of the following custom number formats would work?
2. Regarding the number 1,145 to display as “Invoice No. 001145, which of the following custom number formats would work?”
“Invoice No. “&000000
“Invoice No. “000000
3. What does the ‘#’ symbol represent in custom number formatting?
It requires Excel to display a number whether or not one is required
It requires Excel to display a number only if required
This signifies that there is not enough room to display the number in the cell
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement