International dating format blackindian dating

You are stuck with this format in every region, whether it’s relevant or not.The proper way to “see” a different region’s date format is to change your computer’s Region setting.When I mention regional settings on my computer, I’m talking about Windows and not Excel.

However, the underlying Serial Date remains the same so all they have to do is change the date format to something they recognize in their region and the correct date will display.

I thought that would be the case; so its good to be reassured that the date will display in the custom format, irrespective of the regional settings.

Excel Local Date format UK " data-medium-file=" data-large-file=" class="alignnone size-full wp-image-8154" title="Excel Local Date format UK" src=" alt="Excel Local Date format UK" width="524" height="471" srcset=" sizes="(max-width: 524px) 100vw, 524px" / Bad move.

First of all, look at the picture above and notice there are no date formats that have a leading asterisk (*) which means that no date format will survive a change to a different region.

is there a way to create a custom format that updates with regional settings (i.e. Thanks, ET I have exported some data files in to excel, and now excel reads some dates to month and months to date, I am not able to understand why is this happening, first time I have come across such situation.

I am from India and here format is dd/mm/yyyy and data was also in this format and now, when it got exported excel is reading mm to dd.

Windows Regional Settings (Navigation to) " data-medium-file=" data-large-file=" src=" alt="Windows Regional Settings (Navigation to)" title="Windows Regional Settings (Navigation to)" width="441" height="158" class="alignnone size-full wp-image-8162" srcset=" sizes="(max-width: 441px) 100vw, 441px" / Next click the link for Change the date, time, or number format.

Windows Control Panel Regional Format Settings " data-medium-file=" data-large-file=" src=" alt="Windows Control Panel Regional Format Settings" title="Windows Control Panel Regional Format Settings" width="286" height="78" class="alignnone size-full wp-image-8163" / On the Region and Language dialog box click the Formats tab.

Occasionally I have to work with dates formatted in the US-style. However, I’m curious to know whether a file (with dates formatted like this) sent to a user with a different regional date format setting would display wrongly on her system ?

Tags: , ,