Back to lesson
1. What does the custom number formatting operator “\” do?
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 allows spacing for the next character
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
“;;;” 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.
It forces all formatting back to default spreadsheet settings
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement