Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Problem with date format
I have an excel sheet that contains (amongst other data) a date of birth
formatted in UK style dd/mm/yyyy. On merging into word the date appears as US format (i.e. mm/dd/yyyy) I have checked that the regional settings in Windows, Word and Excel are set to UK not US. Any help gratefully apreciated. Gavin. Oh yes, I'm using Word/Excel 2002 on XP Home SP2 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Problem with date format
Now sorted...
I had worked out that using the field codes I could change the date format using the switch \@"dd/MM/yyy", but it had not been working. Realised I had typed it as /@... Schoolboy error! Gavin. "Gavin Philpott" wrote in message ... I have an excel sheet that contains (amongst other data) a date of birth formatted in UK style dd/mm/yyyy. On merging into word the date appears as US format (i.e. mm/dd/yyyy) I have checked that the regional settings in Windows, Word and Excel are set to UK not US. Any help gratefully apreciated. Gavin. Oh yes, I'm using Word/Excel 2002 on XP Home SP2 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Problem with date format
Hi. I'm experience this problem. I have in excel this date: 17-01-2006 but
then after the mail merge it appears has 01/17/2006. I tried to format, I change to toogle and format as you told me, I get this filead: {Mergefield Data \@ "dd/mm/yyyy" } and this result: 17/00/2006 Why the months apears as zeros? I even tried to change in Regional Setting the short date to dd/mm/aa but nothing. The best that I could get was making a trick. After all register in Excel, I insert another register and I put some text into the date column. Any ideas? Regards, Marco "Gavin Philpott" wrote: Now sorted... I had worked out that using the field codes I could change the date format using the switch \@"dd/MM/yyy", but it had not been working. Realised I had typed it as /@... Schoolboy error! Gavin. "Gavin Philpott" wrote in message ... I have an excel sheet that contains (amongst other data) a date of birth formatted in UK style dd/mm/yyyy. On merging into word the date appears as US format (i.e. mm/dd/yyyy) I have checked that the regional settings in Windows, Word and Excel are set to UK not US. Any help gratefully apreciated. Gavin. Oh yes, I'm using Word/Excel 2002 on XP Home SP2 |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Problem with date format
Hi. I already find out my problem. I wasn't using M in upper case. I was
using mm. Marco "Marco" wrote: Hi. I'm experience this problem. I have in excel this date: 17-01-2006 but then after the mail merge it appears has 01/17/2006. I tried to format, I change to toogle and format as you told me, I get this filead: {Mergefield Data \@ "dd/mm/yyyy" } and this result: 17/00/2006 Why the months apears as zeros? I even tried to change in Regional Setting the short date to dd/mm/aa but nothing. The best that I could get was making a trick. After all register in Excel, I insert another register and I put some text into the date column. Any ideas? Regards, Marco "Gavin Philpott" wrote: Now sorted... I had worked out that using the field codes I could change the date format using the switch \@"dd/MM/yyy", but it had not been working. Realised I had typed it as /@... Schoolboy error! Gavin. "Gavin Philpott" wrote in message ... I have an excel sheet that contains (amongst other data) a date of birth formatted in UK style dd/mm/yyyy. On merging into word the date appears as US format (i.e. mm/dd/yyyy) I have checked that the regional settings in Windows, Word and Excel are set to UK not US. Any help gratefully apreciated. Gavin. Oh yes, I'm using Word/Excel 2002 on XP Home SP2 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Day and Month fields swapped on one PC only? | Mailmerge | |||
date format in form field | Microsoft Word Help | |||
change date format using autocomplete | Microsoft Word Help | |||
Insert Field - Database - Wrong Date Format | Mailmerge | |||
How do I change the date format to a long date after merging it | Mailmerge |