Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Marie Marie is offline
external usenet poster
 
Posts: 33
Default mailmerge date wrong format

When I run the mailmerge, picking up fields from an excel spreadsheet, the
date feild display in american format. They are formated in excel as
australian and display correctly in excel. My computer is set to aussie date
format - what can I do?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default mailmerge date wrong format

See the Mail Merge and Date Fields section of the following page of fellow
MVP Graham Mayor's website:

http://www.gmayor.com/formatting_word_fields.htm

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"Marie" wrote in message
...
When I run the mailmerge, picking up fields from an excel spreadsheet, the
date feild display in american format. They are formated in excel as
australian and display correctly in excel. My computer is set to aussie
date
format - what can I do?


  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default mailmerge date wrong format

Also see the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002/2003" section of fellow MVP Cindy
Meister's website at:

http://homepage.swissonline.ch/cindy...r/MergFram.htm

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"Marie" wrote in message
...
When I run the mailmerge, picking up fields from an excel spreadsheet, the
date feild display in american format. They are formated in excel as
australian and display correctly in excel. My computer is set to aussie
date
format - what can I do?


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Date format wrong when using shortcut key D Brian New Users 4 February 11th 10 01:38 PM
wrong date format in mail merge Trainer New Users 3 April 20th 09 05:54 PM
Mailmerge date format Ocean Mailmerge 5 April 9th 06 06:28 PM
Insert Field - Database - Wrong Date Format dns2005 Mailmerge 3 February 23rd 06 04:04 PM
Wrong mail merge date format sam Mailmerge 1 June 8th 05 01:23 PM


All times are GMT +1. The time now is 11:59 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"