Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
JayJay JayJay is offline
external usenet poster
 
Posts: 4
Default Merged Date Field Converting from Australian layout to American

I'm trying to do a mail merge letter, however, when I try and merge a date
from Excel spreadsheet to Word it converts the date from Australian layout
(dd/mm/yyyy) to US layout (mm/dd/yyyy). Is there any way I can change the
layout of the date? I've tried but I'm not getting anywhere. The date in
the spreadsheet is the correct layout (dd/mm/yyyy) but it changes when it
comes across.

Thanks!
 
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
How do you edit a merged date field? MKRouanzoin Mailmerge 1 May 24th 06 06:29 AM
IF then with merged date field from excel Holly Mailmerge 3 January 14th 06 07:05 AM
how do change the american date to the european date? merging from excel to word Mailmerge 1 August 27th 05 06:35 PM
How do I change my spell check to Australian English not American. Jo Microsoft Word Help 1 April 20th 05 03:33 AM
How do I prevent a merged date field from wrapping? Glenn Mailmerge 1 January 26th 05 04:46 PM


All times are GMT +1. The time now is 03:58 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"