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.




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users

 
  • <i></i>

    Putting the new school year in perspective

    A new school year is upon us, for some it will be their very first, and Andrew Daddo has some sage words of advice to help put it all in perspective.

  • eb-octonauts-thumb

    Win an Octonauts prize pack

    To celebrate the launch of Octonauts Live! Operation Reef Shield, a spectacular underwater adventure live on stage, we are giving away an amazing Octonauts prize pack to one lucky fan.

  • ek-southcoast-thumb

    WIN prizes to top attractions on South Coast NSW

    Shoalhaven Tourism and Kiama Tourism together with a number of leading local businesses are giving away some great prizes which are sure to entertain the whole family. Enter Now!

  • ek-gruffalo-julia-thumb

    Win tickets to Julia Donaldson event

    HURRY, ENTRIES CLOSE TODAY! A magical hour of storytelling and sing-alongs with Julia from her best-loved storybooks, including The Gruffalo, What the Ladybird Heard, Room on the Broom and The Snail and the Whale. Win Melbourne, Geelong & Sydney tickets.

 
Advertisement
 
 
Advertisement
 
 
 
Advertisement
 
 
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.