Search for courses or lessons
Redeem a coupon
Start free trial
Assuming that your version of Excel doesn't give you a default option formatting dates in a year-month-day format, how would you format the "Sales up to" column to display the dates as 2018-12-09, 2018-12-11 and 2018-12-10?
Go to Format Cells, choose Number and then Custom and set the Type to yyyy-m-d
Go to Format Cells, select Date and choose Jan 22, 2013
Go to Format Cells, choose Number and then Custom and set the Type to yyyy-mm-dd
By default, the values in the Product # column of the table shown below will not have leading zeros. How would you force Excel to show them?
Go to Format Cells and select Number and then Custom and set the Type to 000000
Format the cell as text
Type 001234 in the cell
Suppose the value 134567 is in a cell. When this value is formatted with the custom number format ###-###-###, what does it look like?
Back to the top
© 2020 GoSkills Ltd.
Skills for career advancement