Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Suzanne Suzanne is offline
external usenet poster
 
Posts: 53
Default Beyond frustrated with mailmerge date format

Over an hour spent on this stupid...

I've changed all my Excel date formats to a specified "Date" format:
"dd-mmm-yyyy" (vice "Custom: yyyyMMMdd") (didn't help)

I've opened my Excel spreadsheet as the data source (not working)

I've opened using "Connect to new data source.odc" as the data source (not
working)

I re-opened (refreshed) the data source after changing the Excel spreadsheet
(not working)

I've spent considerable time looking at old posts (not helping as of yet)

I'm testing dates on a plain page -- the only thing on the page are the
following mergefield codes -- which are consistently resulting as "39375"

{MERGEFIELD "STARTDATE"}
{MERGEFIELD "STARTDATE" \@ "dd-mmm-yyyy"}

What do I need to do to get my date to show up as 20-Oct-2007 (or better
yet, "20071020")?

BTW, telling me to update a service pack won't do me any good -- I'm on a
system which, for the most part, is locked down by administrators (I assume
they have already installed all the service packs anyway)

 
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
Mailmerge date format Ocean Mailmerge 5 April 9th 06 06:28 PM
US / English date format mailmerge Bento72 Mailmerge 1 February 7th 06 01:57 PM
convert date format after mailmerge David.W. Mailmerge 1 May 9th 05 12:25 PM
Mailmerge changing date format Diane@Adlam Mailmerge 1 April 21st 05 04:35 PM
Mailmerge in Word, date format in merged doc brownsox Mailmerge 2 January 14th 05 12:29 PM


All times are GMT +1. The time now is 05:41 AM.

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"