Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Smudge Smudge is offline
external usenet poster
 
Posts: 16
Default Date Format from Excel Field

Hi all,

Sorry about the subject line

I'm using mail-merge to produce daily signing in sheets. Mail merge fields
are just day of the week and date. Start date can be entered on an excel
sheet and subsequent days and dates fill in using a formula.

My problem is that even though I've changed the format to custom ddmmyy (or
something like that) it's displaying in the merge field as 03/06/2007.

Any ideas please?

--
Smudge
  #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 Date Format from Excel Field

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/cindy...r/MergFram.htm


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

"Smudge" wrote in message
news
Hi all,

Sorry about the subject line

I'm using mail-merge to produce daily signing in sheets. Mail merge fields
are just day of the week and date. Start date can be entered on an excel
sheet and subsequent days and dates fill in using a formula.

My problem is that even though I've changed the format to custom ddmmyy
(or
something like that) it's displaying in the merge field as 03/06/2007.

Any ideas please?

--
Smudge



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Smudge Smudge is offline
external usenet poster
 
Posts: 16
Default Date Format from Excel Field

Many thanks it worked a treat!
--
Smudge


"Doug Robbins - Word MVP" wrote:

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/cindy...r/MergFram.htm


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

"Smudge" wrote in message
news
Hi all,

Sorry about the subject line

I'm using mail-merge to produce daily signing in sheets. Mail merge fields
are just day of the week and date. Start date can be entered on an excel
sheet and subsequent days and dates fill in using a formula.

My problem is that even though I've changed the format to custom ddmmyy
(or
something like that) it's displaying in the merge field as 03/06/2007.

Any ideas please?

--
Smudge




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 field in Excel loses format in Word merge Cone Mailmerge 1 February 24th 07 03:13 PM
Date Field Format Lesley Microsoft Word Help 2 January 11th 06 04:53 PM
Format the field of DATE LS Mailmerge 1 January 9th 06 12:49 PM
date field format lynn atkinson Mailmerge 4 April 5th 05 08:34 AM
Date issue merging from Excel field in Date format to Word Barb Reinhardt Mailmerge 1 December 17th 04 07:34 AM


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