| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop UK-style dates changing to US-style dates when mailmerging.
Using Office 2007. When I use Excel as the database and mailmerge in Word,
all my UK-style dates (eg 25/04/2003) change to US-style (eg 04/25/2003). Does anyone know, please, what can I do to format the dates, either in Excel or Word, to ensure they keep the UK format? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stop UK-style dates changing to US-style dates when mailmerging.
Go to Control Panel/Regional Settings and ensure that all items in each of
the 4 tabs are set correctly. Also, highlight the cells in Excel that contain the dates that are causing the problem, select Format/FormatCells/Date and ensure the Locale is correct also. "Jean XO" <Jean wrote in message ... Using Office 2007. When I use Excel as the database and mailmerge in Word, all my UK-style dates (eg 25/04/2003) change to US-style (eg 04/25/2003). Does anyone know, please, what can I do to format the dates, either in Excel or Word, to ensure they keep the UK format? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change sheet notation from R1C1 style to A1 style in XL 2 | Setting up and Configuration of Excel | |||
| Changing from format style to list style | Excel Worksheet Functions | |||
| How do I convert US style dates to European style? | Excel Discussion (Misc queries) | |||
| can a1 reference style and r1c1 style be used in same formula? | Excel Worksheet Functions | |||
| Mailmerging dates to labels autoformat from date to general help! | Excel Discussion (Misc queries) | |||
Linear Mode
