Jump to content

Mail merge help please
excel to word

  • Please log in to reply
1 reply to this topic

#1 seayork2002

Posted 21 February 2013 - 10:31 AM

I have a spreadsheet which has all dates in the correct way (Australian) and as far as I am aware the settings for the document are set to Australia, same as the word doecument I am merging into but when I go into the word document it comes up as the American date layout.

I have been through all areas that I think are the problem and everything says Australian but obviously I amissing something, can anyone help?

Thanking you in advance.

#2 2anewme

Posted 21 February 2013 - 11:16 AM

Sounds like it has to do with the field that you are merging into in word.

When you are picking your fields to enter your data, check the formatting of the date there.  It may mean that you will have to remove the field and start again.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users


Top 5 Viewed Articles

Essential Baby and Essential Kids is the place to find parenting information and parenting support relating to conception, pregnancy, birth, babies, toddlers, kids, maternity, family budgeting, family travel, nutrition and wellbeing, family entertainment, kids entertainment, tips for the family home, child-friendly recipes and parenting. Try our pregnancy due date calculator to determine your due date, or our ovulation calculator to predict ovulation and your fertile period. Our pregnancy week by week guide shows your baby's stages of development. Access our very active mum's discussion groups in the Essential Baby forums or the Essential Kids forums to talk to mums about conception, pregnancy, birth, babies, toddlers, kids and parenting lifestyle. Essential Baby also offers a baby names database of more than 22,000 baby names, popular baby names, boys' names, girls' names and baby names advice in our baby names forum. Essential Kids features a range of free printable worksheets for kids from preschool years through to primary school years. For the latest baby clothes, maternity clothes, maternity accessories, toddler products, kids toys and kids clothing, breastfeeding and other parenting resources, check out Essential Baby and Essential Kids.