Excel 2010 windows use mac format for dates
Both the Windows and the Mac computers have English Installations with Norwegian local settings for formatting. Thus the names for formulas in Excel are English, but semicolon is used as separators in the formulas.
Was this information helpful?
Line 5 in Figure 1 and 3 shows an identical date value, but after formatting with the Text formula in line 6, the output on the Mac computer is wrong and suddenly outputs the word "Sunday" instead of "". Why does this happen?
Date systems in Excel - Office SupportFor illustration, I have also created two additional alternatives wincows Figure 1 and 3, showing that text formatting with "yyyy" for year does not work on either computers, and lastly that the unknown parameter "eeee" will show correct year output on both computers I do not know what the "eeee" value stands for, but wonder if I am forced to use this value undocumented in Excel help as far as I can see as this works for both computers.
This thread is locked.
Date Format issue with Excel for MAC - Stack Overflow
You can follow the question or vote as helpful, but you cannot reply to this thread. It would take more detailed investigation, but I suspect that the problem here is just incompatibility between MacOS and Windows with regard to the date format codes for Norway regions.
In the attached screen shots from Windows and Mac, you can see that the format code for year differs between MacOS and Windows. The format code is within the double-quotes in the TEXT function, which means it's not stored as one of Excel's internal format codes.
The 1904 date system
Excle I believe Excel needs to ask MacOS, "what is the code used to indicate the year in the current region? Instead of using the TEXT function, if you calculate the date, and then use Windowss Format to set the date format, Excel should always be able to show the proper format regardless of OS and regardless of Region.
So if you create the workbook in Norway and share it with someone in an English locale, it will still show the desired format, even if the characters used in that region are different. To summarize, I recommend only using the TEXT function in cases where you need to concatenate some other text to the date.
Format a date the way you want - Office Support
If the cell will only contain the date, then I would rely on cell number formatting to get the desired format. Did this solve your problem? Yes No. Sorry this didn't help.
Date formatting, moving excel file from Windows to Mac - Microsoft Community
Asked 5 years, 9 months ago. Active 4 years, 9 months ago. Viewed times. Maybe you can try: cells 6,3.
CRondao CRondao 1, 2 2 gold badges 9 9 silver badges 10 10 bronze badges. Sign up or log in Sign up using Google.
Choose from a list of date formats. Follow these steps: Select the cells you want to format. Press CTRL+1. On a Mac, press Control+1 or Command+1. In the Format Cells box, click the Number tab. In the Category list, click Date. Under Type, pick a date format. When you enter a date, it is converted into a serial number that represents the number of days elapsed since January 1, For example, if you enter July 5, , Excel converts the date to the serial number This is the default date system in Excel for Windows, Excel for Mac, and Excel for Mac Formatting Date and Time in Excel Dates can be entered in almost any format in Excel You can type them in the various formats, e.g. 7/20, July, July 20, 7/20/10, July , but by default they will be displayed as July, 7/20/ or Jul once you hit the Enter key.Sign up using Facebook. Sign up using Email and Password.
How to Format numbers and dates in Excel In a excel workbook when you enter numbers, all of them are formatted in a similar manner. You can choose to add different signs to them or even increase and decrease their decimal places etc. When you enter a date, it is converted into a serial number that represents the number of days elapsed since January 1, For example, if you enter July 5, , Excel converts the date to the serial number This is the default date system in Excel for Windows, Excel for Mac, and Excel for Mac Choose from a list of date formats. Follow these steps: Select the cells you want to format. Press CTRL+1. On a Mac, press Control+1 or Command+1. In the Format Cells box, click the Number tab. In the Category list, click Date. Under Type, pick a date format.Post as a guest Name. Email Required, but never shown. New post notices: Improving feedback on Stack Overflow questions. Featured on Meta.