date format problem



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

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

John Inzer

David said:
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

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



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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question