Search for courses or lessons
Redeem a coupon
Start free trial
If you wanted to guarantee that Jan 22, 2013 is displayed in an ISO compliant format (2013-01-22), what would you do?
Go to Format Cells > Number > Custom and set the Type to: yyyy-m-d
Go to Format Cells > Date > Choose Jan 22, 2013
Go to Format Cells > Number > Custom and set the Type to: yyyy-mm-dd
Assuming that you have the number 1234 in B6, and you need it to read 001234. Which of the following methods would fix this?
Type 001234 in the cell.
Go to Format Cells > Number > Custom and set the Type to: 000000
Format the cell as text
Assuming the value 134567 is in a cell, what would it look like if it was formatted with the following custom number format? ###-###-###
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement