Home Questions Tags Users Unanswered. Asked 5 years, 8 months ago. Active 1 year ago. Viewed times. Milliways Milliways 3, 14 14 gold badges 39 39 silver badges 62 62 bronze badges.
Subscribe to RSS
I've got the same problem too, so you're not alone. It's driving me nuts. YellowsBest YellowsBest 21 1 1 bronze badge. Answers on Ask Different need to be more than just a link. It's okay to include a link, but please summarize or excerpt it in the answer. Toggle navigation.
Follow these steps to do your formatting: Select the cell or cells you want to format. Choose Cells from the Format menu. Excel displays the Format Cells dialog box. Make sure the Number tab is selected. Click Date at the left side of the dialog box. See Figure 1.
Figure 1. The Number tab of the Format Cells dialog box.
Convert date to text
Using the Locale drop-down list, choose a country or region that uses the date format you want to use. In the case of Jerry's need, picking English United Kingdom is a good choice. Excel modifies the date formats available to you. Select the desired date format. Click on OK. Author Bio. Workaround for Multiple Rows of Worksheet Tabs If you've got a lot of worksheets in your workbook, you may want to display their tabs in to rows at the bottom of the Discover More. Rechecking Spelling and Grammar If you ever need to check the spelling or grammar of a document from scratch, it can be confusing knowing the proper Finding Fields Fields allow you to add simple dynamic content to your document.
More ExcelTips menu. Converting an Unsupported Date Format Excel makes it easy to import information created in other programs.
Date Format in Excel for Mac - Microsoft Community
Date for Next Wednesday When working with dates, it is often helpful to be able to calculate some date in the future based on a starting date. Adjusting Date Values by Keypress Excel allows you to store dates in a cell. Delete a date element from any format bar by clicking on it and pressing Delete. Type in or click and drag elements to format your "Medium" date. Type in or click and drag elements to format your "Long" date. Type in or click and drag elements to format your "Full" date.
Click Restore Defaults at the bottom left of the window to return to Mac's default date format. Click OK. Click the red "x" button.
Your date format changes will be made! Include your email address to get a message when this question is answered. Already answered Not a question Bad question Other. Edit Related wikiHows. Article Info This article was co-authored by our trained team of editors and researchers who validated it for accuracy and comprehensiveness.