Back to lesson
1. What does the custom number formatting operator “\” do?
It allows spacing for the next character
It denotes that the next character is to be treated as text (this is here so that quotation marks (“) can be included in number formatting if required)
It will divide the number by whatever value is typed next
2. Which of the following custom number types would make the value zero and zero only appear as “-“ rather than “0”?
3. What does the custom number formatting “;;;” do?
It requires only text values to be displayed
It forces all formatting back to default spreadsheet settings
“;;;” explains formatting for positive; negative; zero; text. Since none is specified, all non-error values will not be displayed in the cell either on screen or upon printing.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement