Under "Date formats," you'll notice there is more flexibility to change the date format. This filter no longer works in Excel 2007 as it expects to find the date in mm/dd/yyyy format. A Japanese person reading the generated date 03/04/02 in an English document might mistakenly assume that this used an English ordering. Convert Euro date to US date with formula. Inserting a date from a database into a Japanese page with a Japanese format would be very helpful for the user. Click on the Date tab. 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.. In Excel I have a series of filters, one of which uses a date in dd/mm/yyyy format. I recently bought Office Pro 2007, having previously had Office Pro 2003. Learn how to write the date in different parts of the world and various situations. (yy)yy (using dots (which denote ordinal numbering)) is the traditional German date format. The European Data Format (EDF) is a simple and flexible format for exchange and storage of multichannel biological and physical signals. If you need VBA to understand your local date format, use: Sub hello() ActiveSheet.Cells(1, 1) = DateValue("10/01/2014") End Sub The dates on the web page were in the European date format (i.e., dd/mm/yyyy). (The format d(d).m(m). US date format versus European format. 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. 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 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. When pasted, they looked the same (dd/mm/yyyy) and the formatting for the filled cells was "General." Thansk, Viv. 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: Fortunately, there is one solution in the ISO-developed international date format. It was developed by a few European 'medical' engineers who first met at the 1987 international Sleep Congress in Copenhagen. Here is a formula can convert Euro date format to US date format. Working with European Date Format in Microsoft Word Navigation menu About the "QA Tips" Can anyone refresh my memory please? American colonists favoured the monthly format, while the British Empire drifted towards the European style of dd-mm-yyyy. Find out when to use a comma and when to abbreviate. Is it posible to set a default date format (to the european standard, like YYY.MM.DD, or Norwegian standard DD.MM.YYYY).