Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / October 2007

Tip: Looking for answers? Try searching our database.

Merging Excel to Word

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Geri - 19 Oct 2007 15:26 GMT
Hi there, I'm merging an excel sheet into Word and the date format is coming
out americanised ie mmddyyyy instead of ddmmyyyy, someone via this site has  
given me the correct codes but they are still not working, when I'm pressing
shift F9 to change they are coming up as the correct format, but still
showing wrongly, is there any known bugs with this that there is a patch to
fix it?

Any help would be greatly received
Warmest Regards
Geri
Peter Jamieson - 19 Oct 2007 17:40 GMT
If you are using Word/Excel XP (2002) as far as I know this problem should
have been fixed by a service pack some years ago (I think 2002 is up to
Service Pack 3 (SP3) now - you can get these packs from the microsoft web
site - see http://www.microsoft.com/downloads ,or if you are in a corporate
environment you would typically have to ask your I.T. support people.

Otherwise, which version of Word, Excel and Windows?

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> Hi there, I'm merging an excel sheet into Word and the date format is
> coming
[quoted text clipped - 10 lines]
> Warmest Regards
> Geri
Geri - 25 Oct 2007 11:21 GMT
Hi Peter, sorry for taking so long to get back to you, but thanks for your
help the versions are;

Word 2003 SP2
Excel 2003 SP2
XP Professional 2002 SP2

I am really stumped with this one, any help would be much appreciated

Warmest regards
Geri

> If you are using Word/Excel XP (2002) as far as I know this problem should
> have been fixed by a service pack some years ago (I think 2002 is up to
[quoted text clipped - 18 lines]
> > Warmest Regards
> > Geri
Peter Jamieson - 25 Oct 2007 16:37 GMT
OK, at the moment I am on Office 2003 SP3 and I do not see this with the
examples I am using but
a. can you select one of the offending dates in Excel and tell us what
format you see in Format|Cells (and what the Locale box says underneath)?
b. if all the date cells are formatted the same way but the Locale box says
something other than "English (United Kingdom)" can you try
  - selecting all the cells in the column (except maybe the header cell)
  - in Format Cells, if you don't see "Date", then select Date, select the
"English (United Kingdom)" locale, and select the format you want.

I'm assuming you have the Regional settings in Control Panel set to UK and
the date format in there to the usual DD/MM/YYYY UK settings.

You can always try checking Word Tools|Options|General|Confirm conversions
at open, going through the conneciton process again, and selecting the DDE
option when offered, but that has its own problems and as far as I can see
you should not really have to.
Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> Hi Peter, sorry for taking so long to get back to you, but thanks for your
> help the versions are;
[quoted text clipped - 33 lines]
>> > Warmest Regards
>> > Geri
Doug Robbins - Word MVP - 25 Oct 2007 22:58 GMT
See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002"  section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi Peter, sorry for taking so long to get back to you, but thanks for your
> help the versions are;
[quoted text clipped - 33 lines]
>> > Warmest Regards
>> > Geri
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.