For me, my computer cannot make sense of US date formats such as those shown in the screenshot below. The problem becomes significant when you receive date data in a spreadsheet that is not recognised by your regional settings - or worse, actually is, like my unfortunate project manager mentioned above. Don’t worry though - just follow me in reverse. I apologise, but I am an Australian Brit with the appropriate regional settings on my machine, and it’s a little awkward to perform screenshots that way. Now, I know many readers would prefer this to be the other way around. To show you how to overcome this problem, I will illustrate with converting US dates to what is often known as the “European” date format. This is the danger of 1/3/15, for example. Speaking from personal experience, I remember one project manager was nearly fired after he thought the deadline was 1 March 2015 when it was in fact 3 January 2015. The Format Cells pane will appear, showing the custom format d-mmm. One such country you might have heard of that differs from this “standard” is the US, where it is commonplace to use Month-Day-Year (MDY). Another method to change a date into short date format is through Format Cells. To solve this issue, force the cells into Text format. The most prevalent format worldwide is Day-Month-Year (DMY), but not all countries follow it. However, Excel may sometimes not correctly recognize dates when pasting using the Paste Special option.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |