And that's the result we needed to get to - a text value that looked like a date but didn't behave like one, converted into the correct date format.This example shows the number in our example formatted as a date: Once you choose a date format, the date should be presented as expected. To choose another date format, choose Custom. If you're using a Mac, the the only opNumber formatting dropdown only includes Date. We'll cover custom date formats in another lesson. , or you can choose the More Number Formats option and either choose a different date format or create a custom date format. You can choose from Short Date or Long Date The method is to use the Number formatting dropdown list on the Home ribbon bar. There are a number of ways to format a number as a date.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |