Word-Excel mail merge mark 5/14/2007 3:30:01 PM why do I get a time along with the date when I have it formatted to only show a date

Re: Word-Excel mail merge "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 5/14/2007 3:50:47 PM If you formatted it using a date/time switch in Word, what switch did you use? If you formatted it in Excel, do not expect Word to use the formatting you used - try a date switch in Word, e.g. change { MERGEFIELD mydate } to { MERGEFIELD mydate \[ at ]"MM DDD YY" } substituting whatever format you need. There's an "explanation" of sorts at http://tips.pjmsn.me.uk/t0003.htm Peter Jamieson "mark" <mark[ at ]discussions.microsoft.com> wrote in message news:3C268CAF-5768-4E5F-86B3-E875B2AA95A1[ at ]microsoft.com... [Quoted Text] > why do I get a time along with the date when I have it formatted to only > show > a date

Re: Word-Excel mail merge mark 5/14/2007 5:00:00 PM Where do I do the date switch...Not exactly computer saavy and this is driving me crazy. After the date is displayed in my docs, I see 12:00:00 AM and I'd like to remove that from the docs "Peter Jamieson" wrote: [Quoted Text] > If you formatted it using a date/time switch in Word, what switch did you > use? > > If you formatted it in Excel, do not expect Word to use the formatting you > used - try a date switch in Word, e.g. change > > { MERGEFIELD mydate } > to > { MERGEFIELD mydate \[ at ]"MM DDD YY" } > > substituting whatever format you need. > > There's an "explanation" of sorts at http://tips.pjmsn.me.uk/t0003.htm > > Peter Jamieson > > "mark" <mark[ at ]discussions.microsoft.com> wrote in message > news:3C268CAF-5768-4E5F-86B3-E875B2AA95A1[ at ]microsoft.com... > > why do I get a time along with the date when I have it formatted to only > > show > > a date >

Re: Word-Excel mail merge "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 5/14/2007 5:18:35 PM With your Word document open, press Alt-F9 to see the field codes. They look like { MERGEFIELD mydate } rather than <<mydate>> Then type the "format switch" text after the field name and before the "}", as previously suggested. If you already have a switch that looks like "\*Mergeformat", in most cases it won't do any harm to delete it. Peter Jamieson "mark" <mark[ at ]discussions.microsoft.com> wrote in message news:801E865F-C0CD-4FEE-BE22-D2431AD876BB[ at ]microsoft.com... [Quoted Text] > Where do I do the date switch...Not exactly computer saavy and this is > driving me crazy. After the date is displayed in my docs, I see 12:00:00 > AM > and I'd like to remove that from the docs > > "Peter Jamieson" wrote: > >> If you formatted it using a date/time switch in Word, what switch did you >> use? >> >> If you formatted it in Excel, do not expect Word to use the formatting >> you >> used - try a date switch in Word, e.g. change >> >> { MERGEFIELD mydate } >> to >> { MERGEFIELD mydate \[ at ]"MM DDD YY" } >> >> substituting whatever format you need. >> >> There's an "explanation" of sorts at http://tips.pjmsn.me.uk/t0003.htm >> >> Peter Jamieson >> >> "mark" <mark[ at ]discussions.microsoft.com> wrote in message >> news:3C268CAF-5768-4E5F-86B3-E875B2AA95A1[ at ]microsoft.com... >> > why do I get a time along with the date when I have it formatted to >> > only >> > show >> > a date >>

Re: Word-Excel mail merge mark 5/14/2007 6:01:00 PM Thank You Peter,it worked great....I have one final question if you can help me. A monetary amount is showing up as 92800. when I would like it to show up as $92,800.00. Any suggestions? "Peter Jamieson" wrote: [Quoted Text] > With your Word document open, press Alt-F9 to see the field codes. They look > like { MERGEFIELD mydate } rather than <<mydate>> > > Then type the "format switch" text after the field name and before the "}", > as previously suggested. > > If you already have a switch that looks like "\*Mergeformat", in most cases > it won't do any harm to delete it. > > Peter Jamieson > > > "mark" <mark[ at ]discussions.microsoft.com> wrote in message > news:801E865F-C0CD-4FEE-BE22-D2431AD876BB[ at ]microsoft.com... > > Where do I do the date switch...Not exactly computer saavy and this is > > driving me crazy. After the date is displayed in my docs, I see 12:00:00 > > AM > > and I'd like to remove that from the docs > > > > "Peter Jamieson" wrote: > > > >> If you formatted it using a date/time switch in Word, what switch did you > >> use? > >> > >> If you formatted it in Excel, do not expect Word to use the formatting > >> you > >> used - try a date switch in Word, e.g. change > >> > >> { MERGEFIELD mydate } > >> to > >> { MERGEFIELD mydate \[ at ]"MM DDD YY" } > >> > >> substituting whatever format you need. > >> > >> There's an "explanation" of sorts at http://tips.pjmsn.me.uk/t0003.htm > >> > >> Peter Jamieson > >> > >> "mark" <mark[ at ]discussions.microsoft.com> wrote in message > >> news:3C268CAF-5768-4E5F-86B3-E875B2AA95A1[ at ]microsoft.com... > >> > why do I get a time along with the date when I have it formatted to > >> > only > >> > show > >> > a date > >> >

Re: Word-Excel mail merge "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 5/14/2007 6:25:42 PM Change { MERGEFIELD myamount } to { MERGEFIELD myamount \#"$,0.00" } Peter Jamieson "mark" <mark[ at ]discussions.microsoft.com> wrote in message news:802ABC25-C858-4F09-8930-D2E6EC66A8B3[ at ]microsoft.com... [Quoted Text] > Thank You Peter,it worked great....I have one final question if you can > help > me. A monetary amount is showing up as 92800. when I would like it to > show > up as $92,800.00. Any suggestions? > > "Peter Jamieson" wrote: > >> With your Word document open, press Alt-F9 to see the field codes. They >> look >> like { MERGEFIELD mydate } rather than <<mydate>> >> >> Then type the "format switch" text after the field name and before the >> "}", >> as previously suggested. >> >> If you already have a switch that looks like "\*Mergeformat", in most >> cases >> it won't do any harm to delete it. >> >> Peter Jamieson >> >> >> "mark" <mark[ at ]discussions.microsoft.com> wrote in message >> news:801E865F-C0CD-4FEE-BE22-D2431AD876BB[ at ]microsoft.com... >> > Where do I do the date switch...Not exactly computer saavy and this is >> > driving me crazy. After the date is displayed in my docs, I see >> > 12:00:00 >> > AM >> > and I'd like to remove that from the docs >> > >> > "Peter Jamieson" wrote: >> > >> >> If you formatted it using a date/time switch in Word, what switch did >> >> you >> >> use? >> >> >> >> If you formatted it in Excel, do not expect Word to use the formatting >> >> you >> >> used - try a date switch in Word, e.g. change >> >> >> >> { MERGEFIELD mydate } >> >> to >> >> { MERGEFIELD mydate \[ at ]"MM DDD YY" } >> >> >> >> substituting whatever format you need. >> >> >> >> There's an "explanation" of sorts at http://tips.pjmsn.me.uk/t0003.htm >> >> >> >> Peter Jamieson >> >> >> >> "mark" <mark[ at ]discussions.microsoft.com> wrote in message >> >> news:3C268CAF-5768-4E5F-86B3-E875B2AA95A1[ at ]microsoft.com... >> >> > why do I get a time along with the date when I have it formatted to >> >> > only >> >> > show >> >> > a date >> >> >>

Re: Word-Excel mail merge mark 5/14/2007 7:13:01 PM Thanks again Peter for the quick response "Peter Jamieson" wrote: [Quoted Text] > Change > > { MERGEFIELD myamount } > > to > > { MERGEFIELD myamount \#"$,0.00" } > > Peter Jamieson > > "mark" <mark[ at ]discussions.microsoft.com> wrote in message > news:802ABC25-C858-4F09-8930-D2E6EC66A8B3[ at ]microsoft.com... > > Thank You Peter,it worked great....I have one final question if you can > > help > > me. A monetary amount is showing up as 92800. when I would like it to > > show > > up as $92,800.00. Any suggestions? > > > > "Peter Jamieson" wrote: > > > >> With your Word document open, press Alt-F9 to see the field codes. They > >> look > >> like { MERGEFIELD mydate } rather than <<mydate>> > >> > >> Then type the "format switch" text after the field name and before the > >> "}", > >> as previously suggested. > >> > >> If you already have a switch that looks like "\*Mergeformat", in most > >> cases > >> it won't do any harm to delete it. > >> > >> Peter Jamieson > >> > >> > >> "mark" <mark[ at ]discussions.microsoft.com> wrote in message > >> news:801E865F-C0CD-4FEE-BE22-D2431AD876BB[ at ]microsoft.com... > >> > Where do I do the date switch...Not exactly computer saavy and this is > >> > driving me crazy. After the date is displayed in my docs, I see > >> > 12:00:00 > >> > AM > >> > and I'd like to remove that from the docs > >> > > >> > "Peter Jamieson" wrote: > >> > > >> >> If you formatted it using a date/time switch in Word, what switch did > >> >> you > >> >> use? > >> >> > >> >> If you formatted it in Excel, do not expect Word to use the formatting > >> >> you > >> >> used - try a date switch in Word, e.g. change > >> >> > >> >> { MERGEFIELD mydate } > >> >> to > >> >> { MERGEFIELD mydate \[ at ]"MM DDD YY" } > >> >> > >> >> substituting whatever format you need. > >> >> > >> >> There's an "explanation" of sorts at http://tips.pjmsn.me.uk/t0003.htm > >> >> > >> >> Peter Jamieson > >> >> > >> >> "mark" <mark[ at ]discussions.microsoft.com> wrote in message > >> >> news:3C268CAF-5768-4E5F-86B3-E875B2AA95A1[ at ]microsoft.com... > >> >> > why do I get a time along with the date when I have it formatted to > >> >> > only > >> >> > show > >> >> > a date > >> >> > >> > >

Re: Word-Excel mail merge mark 5/14/2007 7:19:00 PM Well, here we go. I have an address field that is in all upper case. If I change it to proper case, the second letter of the state in the address will be lower case for ex. WEST JORDAN UT 84084 yields West Jordan Ut 84084 Any suggestions? "mark" wrote: [Quoted Text] > Thanks again Peter for the quick response > > "Peter Jamieson" wrote: > > > Change > > > > { MERGEFIELD myamount } > > > > to > > > > { MERGEFIELD myamount \#"$,0.00" } > > > > Peter Jamieson > > > > "mark" <mark[ at ]discussions.microsoft.com> wrote in message > > news:802ABC25-C858-4F09-8930-D2E6EC66A8B3[ at ]microsoft.com... > > > Thank You Peter,it worked great....I have one final question if you can > > > help > > > me. A monetary amount is showing up as 92800. when I would like it to > > > show > > > up as $92,800.00. Any suggestions? > > > > > > "Peter Jamieson" wrote: > > > > > >> With your Word document open, press Alt-F9 to see the field codes. They > > >> look > > >> like { MERGEFIELD mydate } rather than <<mydate>> > > >> > > >> Then type the "format switch" text after the field name and before the > > >> "}", > > >> as previously suggested. > > >> > > >> If you already have a switch that looks like "\*Mergeformat", in most > > >> cases > > >> it won't do any harm to delete it. > > >> > > >> Peter Jamieson > > >> > > >> > > >> "mark" <mark[ at ]discussions.microsoft.com> wrote in message > > >> news:801E865F-C0CD-4FEE-BE22-D2431AD876BB[ at ]microsoft.com... > > >> > Where do I do the date switch...Not exactly computer saavy and this is > > >> > driving me crazy. After the date is displayed in my docs, I see > > >> > 12:00:00 > > >> > AM > > >> > and I'd like to remove that from the docs > > >> > > > >> > "Peter Jamieson" wrote: > > >> > > > >> >> If you formatted it using a date/time switch in Word, what switch did > > >> >> you > > >> >> use? > > >> >> > > >> >> If you formatted it in Excel, do not expect Word to use the formatting > > >> >> you > > >> >> used - try a date switch in Word, e.g. change > > >> >> > > >> >> { MERGEFIELD mydate } > > >> >> to > > >> >> { MERGEFIELD mydate \[ at ]"MM DDD YY" } > > >> >> > > >> >> substituting whatever format you need. > > >> >> > > >> >> There's an "explanation" of sorts at http://tips.pjmsn.me.uk/t0003.htm > > >> >> > > >> >> Peter Jamieson > > >> >> > > >> >> "mark" <mark[ at ]discussions.microsoft.com> wrote in message > > >> >> news:3C268CAF-5768-4E5F-86B3-E875B2AA95A1[ at ]microsoft.com... > > >> >> > why do I get a time along with the date when I have it formatted to > > >> >> > only > > >> >> > show > > >> >> > a date > > >> >> > > >> > > > >

Re: Word-Excel mail merge "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 5/14/2007 8:27:57 PM Hi Mark, To fix this one in a sensible way, you would really have to separate out the two-letter state code from the other data in your data source. What's possible depends on where you're starting from (and just to spell it out, I'm starting from over the large pond to the east of te U.S.A., so for example I don't know if "WEST JORDAN" is a county in Utah or what, if you are dealing with all the U.S. States or just UT, and so on...:-)) Peter Jamieson "mark" <mark[ at ]discussions.microsoft.com> wrote in message news:A7678C49-D895-4AB2-A42D-06BBEB0A3500[ at ]microsoft.com... [Quoted Text] > Well, here we go. I have an address field that is in all upper case. If > I > change it to proper case, the second letter of the state in the address > will > be lower case > > for ex. WEST JORDAN UT 84084 > > yields West Jordan Ut 84084 > > Any suggestions? > > "mark" wrote: > >> Thanks again Peter for the quick response >> >> "Peter Jamieson" wrote: >> >> > Change >> > >> > { MERGEFIELD myamount } >> > >> > to >> > >> > { MERGEFIELD myamount \#"$,0.00" } >> > >> > Peter Jamieson >> > >> > "mark" <mark[ at ]discussions.microsoft.com> wrote in message >> > news:802ABC25-C858-4F09-8930-D2E6EC66A8B3[ at ]microsoft.com... >> > > Thank You Peter,it worked great....I have one final question if you >> > > can >> > > help >> > > me. A monetary amount is showing up as 92800. when I would like it >> > > to >> > > show >> > > up as $92,800.00. Any suggestions? >> > > >> > > "Peter Jamieson" wrote: >> > > >> > >> With your Word document open, press Alt-F9 to see the field codes. >> > >> They >> > >> look >> > >> like { MERGEFIELD mydate } rather than <<mydate>> >> > >> >> > >> Then type the "format switch" text after the field name and before >> > >> the >> > >> "}", >> > >> as previously suggested. >> > >> >> > >> If you already have a switch that looks like "\*Mergeformat", in >> > >> most >> > >> cases >> > >> it won't do any harm to delete it. >> > >> >> > >> Peter Jamieson >> > >> >> > >> >> > >> "mark" <mark[ at ]discussions.microsoft.com> wrote in message >> > >> news:801E865F-C0CD-4FEE-BE22-D2431AD876BB[ at ]microsoft.com... >> > >> > Where do I do the date switch...Not exactly computer saavy and >> > >> > this is >> > >> > driving me crazy. After the date is displayed in my docs, I see >> > >> > 12:00:00 >> > >> > AM >> > >> > and I'd like to remove that from the docs >> > >> > >> > >> > "Peter Jamieson" wrote: >> > >> > >> > >> >> If you formatted it using a date/time switch in Word, what switch >> > >> >> did >> > >> >> you >> > >> >> use? >> > >> >> >> > >> >> If you formatted it in Excel, do not expect Word to use the >> > >> >> formatting >> > >> >> you >> > >> >> used - try a date switch in Word, e.g. change >> > >> >> >> > >> >> { MERGEFIELD mydate } >> > >> >> to >> > >> >> { MERGEFIELD mydate \[ at ]"MM DDD YY" } >> > >> >> >> > >> >> substituting whatever format you need. >> > >> >> >> > >> >> There's an "explanation" of sorts at >> > >> >> http://tips.pjmsn.me.uk/t0003.htm >> > >> >> >> > >> >> Peter Jamieson >> > >> >> >> > >> >> "mark" <mark[ at ]discussions.microsoft.com> wrote in message >> > >> >> news:3C268CAF-5768-4E5F-86B3-E875B2AA95A1[ at ]microsoft.com... >> > >> >> > why do I get a time along with the date when I have it >> > >> >> > formatted to >> > >> >> > only >> > >> >> > show >> > >> >> > a date >> > >> >> >> > >> >> > >> >

Re: Word-Excel mail merge mark 5/31/2007 7:25:02 PM Hi Peter, Everything went pretty well except for an error in the merge in the middle of the data source. I have a set of records that total 6010, and when I merged the data, records 955-2242 yielded no date. Record 954 and record 2243 were fine and printed out correctly. Is it possible that those cells are not properly formatted or could the cells themselves be corrupted in some way? Stuck up creek w/ no paddle Mark "Peter Jamieson" wrote: [Quoted Text] > Hi Mark, > > To fix this one in a sensible way, you would really have to separate out the > two-letter state code from the other data in your data source. What's > possible depends on where you're starting from (and just to spell it out, > I'm starting from over the large pond to the east of te U.S.A., so for > example I don't know if "WEST JORDAN" is a county in Utah or what, if you > are dealing with all the U.S. States or just UT, and so on...:-)) > > Peter Jamieson > > > "mark" <mark[ at ]discussions.microsoft.com> wrote in message > news:A7678C49-D895-4AB2-A42D-06BBEB0A3500[ at ]microsoft.com... > > Well, here we go. I have an address field that is in all upper case. If > > I > > change it to proper case, the second letter of the state in the address > > will > > be lower case > > > > for ex. WEST JORDAN UT 84084 > > > > yields West Jordan Ut 84084 > > > > Any suggestions? > > > > "mark" wrote: > > > >> Thanks again Peter for the quick response > >> > >> "Peter Jamieson" wrote: > >> > >> > Change > >> > > >> > { MERGEFIELD myamount } > >> > > >> > to > >> > > >> > { MERGEFIELD myamount \#"$,0.00" } > >> > > >> > Peter Jamieson > >> > > >> > "mark" <mark[ at ]discussions.microsoft.com> wrote in message > >> > news:802ABC25-C858-4F09-8930-D2E6EC66A8B3[ at ]microsoft.com... > >> > > Thank You Peter,it worked great....I have one final question if you > >> > > can > >> > > help > >> > > me. A monetary amount is showing up as 92800. when I would like it > >> > > to > >> > > show > >> > > up as $92,800.00. Any suggestions? > >> > > > >> > > "Peter Jamieson" wrote: > >> > > > >> > >> With your Word document open, press Alt-F9 to see the field codes. > >> > >> They > >> > >> look > >> > >> like { MERGEFIELD mydate } rather than <<mydate>> > >> > >> > >> > >> Then type the "format switch" text after the field name and before > >> > >> the > >> > >> "}", > >> > >> as previously suggested. > >> > >> > >> > >> If you already have a switch that looks like "\*Mergeformat", in > >> > >> most > >> > >> cases > >> > >> it won't do any harm to delete it. > >> > >> > >> > >> Peter Jamieson > >> > >> > >> > >> > >> > >> "mark" <mark[ at ]discussions.microsoft.com> wrote in message > >> > >> news:801E865F-C0CD-4FEE-BE22-D2431AD876BB[ at ]microsoft.com... > >> > >> > Where do I do the date switch...Not exactly computer saavy and > >> > >> > this is > >> > >> > driving me crazy. After the date is displayed in my docs, I see > >> > >> > 12:00:00 > >> > >> > AM > >> > >> > and I'd like to remove that from the docs > >> > >> > > >> > >> > "Peter Jamieson" wrote: > >> > >> > > >> > >> >> If you formatted it using a date/time switch in Word, what switch > >> > >> >> did > >> > >> >> you > >> > >> >> use? > >> > >> >> > >> > >> >> If you formatted it in Excel, do not expect Word to use the > >> > >> >> formatting > >> > >> >> you > >> > >> >> used - try a date switch in Word, e.g. change > >> > >> >> > >> > >> >> { MERGEFIELD mydate } > >> > >> >> to > >> > >> >> { MERGEFIELD mydate \[ at ]"MM DDD YY" } > >> > >> >> > >> > >> >> substituting whatever format you need. > >> > >> >> > >> > >> >> There's an "explanation" of sorts at > >> > >> >> http://tips.pjmsn.me.uk/t0003.htm > >> > >> >> > >> > >> >> Peter Jamieson > >> > >> >> > >> > >> >> "mark" <mark[ at ]discussions.microsoft.com> wrote in message > >> > >> >> news:3C268CAF-5768-4E5F-86B3-E875B2AA95A1[ at ]microsoft.com... > >> > >> >> > why do I get a time along with the date when I have it > >> > >> >> > formatted to > >> > >> >> > only > >> > >> >> > show > >> > >> >> > a date > >> > >> >> > >> > >> > >> > > >> > >

Re: Word-Excel mail merge "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 5/31/2007 9:18:26 PM OK, previous questions have been about date&time, and amounts. [Quoted Text] > Everything went pretty well except for an error in the merge in the middle > of the data source. I have a set of records that total 6010, Do you mean 6010 records, or something else? > and when I > merged the data, records 955-2242 yielded no date. let's look at records 954 (say) and 955. - What is the name of the column you are using as a date? - what do you see in Excel when you look at the data in that column in record 954 and 955? - if you select the relevant cell in record 954 and 955, anduse Excel Format|Cells, do you see any difference in the formatting? > Record 954 and record > 2243 were fine and printed out correctly. Is it possible that those cells > are not properly formatted or could the cells themselves be corrupted in > some > way? Try the above for starters. Yes, what you say is possible, but deciding that something is corrupt rarely helps except in the sense that "corrupt" means "so bad that it's probably a good idea to start from scratch, whatever that might mean" Peter Jamieson "mark" <mark[ at ]discussions.microsoft.com> wrote in message news:9B82F019-95C8-4B50-9322-9CCDC92A292A[ at ]microsoft.com... > Hi Peter, > > Everything went pretty well except for an error in the merge in the middle > of the data source. I have a set of records that total 6010, and when I > merged the data, records 955-2242 yielded no date. Record 954 and record > 2243 were fine and printed out correctly. Is it possible that those cells > are not properly formatted or could the cells themselves be corrupted in > some > way? > > Stuck up creek w/ no paddle > > Mark > > "Peter Jamieson" wrote: > >> Hi Mark, >> >> To fix this one in a sensible way, you would really have to separate out >> the >> two-letter state code from the other data in your data source. What's >> possible depends on where you're starting from (and just to spell it out, >> I'm starting from over the large pond to the east of te U.S.A., so for >> example I don't know if "WEST JORDAN" is a county in Utah or what, if you >> are dealing with all the U.S. States or just UT, and so on...:-)) >> >> Peter Jamieson >> >> >> "mark" <mark[ at ]discussions.microsoft.com> wrote in message >> news:A7678C49-D895-4AB2-A42D-06BBEB0A3500[ at ]microsoft.com... >> > Well, here we go. I have an address field that is in all upper case. >> > If >> > I >> > change it to proper case, the second letter of the state in the address >> > will >> > be lower case >> > >> > for ex. WEST JORDAN UT 84084 >> > >> > yields West Jordan Ut 84084 >> > >> > Any suggestions? >> > >> > "mark" wrote: >> > >> >> Thanks again Peter for the quick response >> >> >> >> "Peter Jamieson" wrote: >> >> >> >> > Change >> >> > >> >> > { MERGEFIELD myamount } >> >> > >> >> > to >> >> > >> >> > { MERGEFIELD myamount \#"$,0.00" } >> >> > >> >> > Peter Jamieson >> >> > >> >> > "mark" <mark[ at ]discussions.microsoft.com> wrote in message >> >> > news:802ABC25-C858-4F09-8930-D2E6EC66A8B3[ at ]microsoft.com... >> >> > > Thank You Peter,it worked great....I have one final question if >> >> > > you >> >> > > can >> >> > > help >> >> > > me. A monetary amount is showing up as 92800. when I would like >> >> > > it >> >> > > to >> >> > > show >> >> > > up as $92,800.00. Any suggestions? >> >> > > >> >> > > "Peter Jamieson" wrote: >> >> > > >> >> > >> With your Word document open, press Alt-F9 to see the field >> >> > >> codes. >> >> > >> They >> >> > >> look >> >> > >> like { MERGEFIELD mydate } rather than <<mydate>> >> >> > >> >> >> > >> Then type the "format switch" text after the field name and >> >> > >> before >> >> > >> the >> >> > >> "}", >> >> > >> as previously suggested. >> >> > >> >> >> > >> If you already have a switch that looks like "\*Mergeformat", in >> >> > >> most >> >> > >> cases >> >> > >> it won't do any harm to delete it. >> >> > >> >> >> > >> Peter Jamieson >> >> > >> >> >> > >> >> >> > >> "mark" <mark[ at ]discussions.microsoft.com> wrote in message >> >> > >> news:801E865F-C0CD-4FEE-BE22-D2431AD876BB[ at ]microsoft.com... >> >> > >> > Where do I do the date switch...Not exactly computer saavy and >> >> > >> > this is >> >> > >> > driving me crazy. After the date is displayed in my docs, I >> >> > >> > see >> >> > >> > 12:00:00 >> >> > >> > AM >> >> > >> > and I'd like to remove that from the docs >> >> > >> > >> >> > >> > "Peter Jamieson" wrote: >> >> > >> > >> >> > >> >> If you formatted it using a date/time switch in Word, what >> >> > >> >> switch >> >> > >> >> did >> >> > >> >> you >> >> > >> >> use? >> >> > >> >> >> >> > >> >> If you formatted it in Excel, do not expect Word to use the >> >> > >> >> formatting >> >> > >> >> you >> >> > >> >> used - try a date switch in Word, e.g. change >> >> > >> >> >> >> > >> >> { MERGEFIELD mydate } >> >> > >> >> to >> >> > >> >> { MERGEFIELD mydate \[ at ]"MM DDD YY" } >> >> > >> >> >> >> > >> >> substituting whatever format you need. >> >> > >> >> >> >> > >> >> There's an "explanation" of sorts at >> >> > >> >> http://tips.pjmsn.me.uk/t0003.htm >> >> > >> >> >> >> > >> >> Peter Jamieson >> >> > >> >> >> >> > >> >> "mark" <mark[ at ]discussions.microsoft.com> wrote in message >> >> > >> >> news:3C268CAF-5768-4E5F-86B3-E875B2AA95A1[ at ]microsoft.com... >> >> > >> >> > why do I get a time along with the date when I have it >> >> > >> >> > formatted to >> >> > >> >> > only >> >> > >> >> > show >> >> > >> >> > a date >> >> > >> >> >> >> > >> >> >> > >> >> > >>