May 18, 2017 Date formatting, moving excel file from Windows to Mac Hello, I hope someone may help with my issue. Windows Excel Text Format Example: Figure2: Windows Regional settings. And then use Number Format to set the date format, Excel should always be able to show the proper format regardless of OS and regardless of Region.
![Excel 2010 Windows Use Mac Format For Dates Excel 2010 Windows Use Mac Format For Dates](/uploads/1/2/5/5/125597853/690056249.jpg)
By Excel 2010 provides several different formats in which to display dates and times in a worksheet. Some date formats appear automatically based on how you type a date entry in a cell. For example, if you type 9/ 10 in a cell, Excel interprets this as a date and changes the entry to 10 -Sep (or whatever your default date format is). Use the Format Cells dialog box to change the way a date appears in the worksheet. You also can use the Number Format drop-down list in the Number group on the Home tab to apply the Short Date, Long Date, or Time format to cell data.