date format problem


M

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
 
Ad

Advertisements

R

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.
 
J

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

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
 
D

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).
 
Ad

Advertisements

D

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.)
 
Ad

Advertisements

D

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

Top