Home › MCQs › Basic Computer/IT › Question #11516
Back to Questions
Basic Computer/IT QUESTION #11516
Question 1
In Excel custom number formatting, the first section of the format code governs:
  • Positive numbers✔️
  • Negative numbers
  • Zero values
  • Text values
Correct Answer Explanation
In Excel's custom number format, the code is divided into up to four sections separated by semicolons: [positive];[negative];[zero];[text]. The first section always describes how positive numbers are displayed. For example, in #,##0.00;-#,##0.00;0;@, the first part applies to positive values.