VBA considers all date literals to be in US format unless the literal cannot possibly be a valid US-formatted date.If you use "10/Jan/2014" (or #10/Jan/2014#; the #s are date literal markers), VBA will fall back to dd/MMM/yyyy since it can't be anything else.. (The format d(d).m(m). Here is a formula can convert Euro date format to US date format. Fortunately, there is one solution in the ISO-developed international date format. (yy)yy (using dots (which denote ordinal numbering)) is the traditional German date format. Convert Euro date to US date with formula. I recently bought Office Pro 2007, having previously had Office Pro 2003. A Japanese person reading the generated date 03/04/02 in an English document might mistakenly assume that this used an English ordering. The dates on the web page were in the European date format (i.e., dd/mm/yyyy). When pasted, they looked the same (dd/mm/yyyy) and the formatting for the filled cells was "General." US date format versus European format. The European Data Format (EDF) is a simple and flexible format for exchange and storage of multichannel biological and physical signals. Click on the Date tab. Is it posible to set a default date format (to the european standard, like YYY.MM.DD, or Norwegian standard DD.MM.YYYY). Inserting a date from a database into a Japanese page with a Japanese format would be very helpful for the user. American colonists favoured the monthly format, while the British Empire drifted towards the European style of dd-mm-yyyy. This filter no longer works in Excel 2007 as it expects to find the date in mm/dd/yyyy format. Thansk, Viv. The worst potential usability problems come when the date is written only with numbers as in the following usa, because the date's interpretation will be european from one clock to another. It was developed by a few European 'medical' engineers who first met at the 1987 international Sleep Congress in Copenhagen. It realy should not be neede to have to change this for every dingle date field in every single document I am making, especially when I am making several documents a day that needs to be signed. Under "Date formats," you'll notice there is more flexibility to change the date format. Working with European Date Format in Microsoft Word Navigation menu About the "QA Tips" Can anyone refresh my memory please? If you need VBA to understand your local date format, use: Sub hello() ActiveSheet.Cells(1, 1) = DateValue("10/01/2014") End Sub In Excel I have a series of filters, one of which uses a date in dd/mm/yyyy format. Find out when to use a comma and when to abbreviate. Select a cell which you will place the US date, for instance, C10, enter this formula =DATE(VALUE(RIGHT(A2,4)), VALUE(MID(A2,4,2)), VALUE(LEFT(A2,2))), drag fill handle down to the cells needed to apply this formula.See screenshot: Learn how to write the date in different parts of the world and various situations. I want to be able to sort this column by date, and thought I could reformat the entries using the "format cells" function to show them in a mm/dd/yyyy format.