date format problem

[Marie]

We print Certificates (merge from an excel data table) and have a date field.
Doesn't seem to matter which way I enter/format the excel field, on the
Publisher Certificate it appears in US format mm/dd/yyyy. We need
dd/mm/yyyy. Thanks

 

[Rob Giordano [MS MVP]]

From F1:

Changing the default country/region changes the standard settings for
numbers, currencies, time, and date to those most commonly used for that
country/region.

Changing default country depends on which OS you're using.

 

[Mary Sauer]

Format the field as text.

 

[David W Powell]

Unfortunately, Publisher (at 2003, anyway) doesn't seem to honour this.

 

[John Inzer]

Unfortunately, Publisher (at 2003, anyway)
doesn't seem to honour this.

============================
Go to...Control Panel / Regional and
Language Options / Regional Options tab...

Try choosing...English (United States)
or...English (United Kingdom)

--

John Inzer MS-MVP
Digital Media Experience

Notice
This is not tech support
I am a volunteer

Solutions that work for
me may not work for you

Proceed at your own risk

 

[David W Powell]

I interpret this to mean "Add a working column to your spreadsheet, which
re-expresses the field as text. Use the name of the working column in your
Publisher document."

It's always good to keep the computational integrity of a date field intact.
The formula in a cell of your working column could look like
=TEXT(B2,"dd mmmm yyyy")
where the 'pure' dates were in column B and the example above is in row 2.

Anyway, directly formatting a date cell as text will simply provide an Excel
date number (in text form).

 

[David W Powell]

I did this, and it shows "English (Australia)", as it should, in my case.
The example Short Date format for today (ISO 2008-12-01), shows "1/12/2008",
as it should. Unfortunately, Publisher doesn't honour this. It'll present
as "12/1/2008" (which we interpret as 12 January). (I know Access is a bit
US-presumptive in this respect, too - though there are more elegant
workarounds.)

 

[David W Powell]

To better tune my example before,
in your case, you want =TEXT(<...>, "dd/mm/yyyy"),
where <...> is the cell containing the date.