Quiz

  1. 1
    Intermediate

    If you wanted to guarantee that Jan 22, 2013 is displayed in an ISO compliant format (2013-01-22), what would you do?

  2. 2
    Intermediate

    Assuming that you have the number 1234 in B6, and you need it to read 001234. Which of the following methods would fix this?

  3. 3
    Intermediate

    Assuming the value 134567 is in a cell, what would it look like if it was formatted with the following custom number format? ###-###-###