Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Merging Excel Data into Word
Hi
I use Word and Excel XP and when we merge dates from an Excel doc into Word, it puts the date in an American format for some reason even though the formatting is Australian. Regional settings are set to Australian. I have managed to edit the field in Word to change the date but was hoping that someone would know why it is behaving like this so I can stop it from happening? We also have problems with some of the forumlas. For example, we might use the currency formula which has two decimal places (ie. $23.09) but it comes into Word like 23.0258. Any ideas why this is happening? Thank you in advance. Kylie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Automation from Excel to Word | Excel Discussion (Misc queries) | |||
How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
combined cell data from Excel to Word (2003) | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Word field codes in Excel data file Includetext | Excel Discussion (Misc queries) |