[mso] Excel and Word mailmerge - number formatting import problems
- From: Anne Robson <anne.robson@xxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Thu, 21 Aug 2003 12:10:36 +0100
Hi all
I have been using Excel and Word to mailmerge data for years and yet have been
completely stopped in my tracks by the problems I have had in my present
task. I'm using Office 2002 BTW.
I have a large amount of data, some text, some currency, some dates, some
general number data stuff. My problems are as follows:
1. Some of the dates (formatted as the equivalent of "d mmmm yyyy" fields)
import from Excel into Word quite successfully. Others import as the date
value codes (eg 58947 or whatever). Why? I have tried retyping, overtyping
etc and the only way I can seem to fix it is by formatting the cells as plain
text, which then means I can't sort on them by date order.
2. Some of the currency fields which are set to GB sterling with currency
symbol in Excel, 2 decimal places, then import into Word with lots of extra
decimal places which may or may not be un-rounded. It means that each time I
want to check my figures I have to go back into a large Excel sheet and see
whether I have got £34,950.95 or £34,950.94699999! Again, why is this and
what can I do to fix it?
3. Similar problem to (2) - percentages seem to gain an extra shedload of
decimal places, which also means I have to go back and check the original data.
4. Some of the currency fields import across into Word with the currency
symbol, others do not. *scratches head to work this one out*
The frustration factor in this is huge as this data is used to provide
correspondence which has to meet a legal compliance test. We cannot -
absolutely never, not ever, no way - have any of the info incorrect.
All suggestions gratefully received. I am rapidly losing my sense of humour
with it! (but not quite, cos I know that some kind soul out there in MSO-land
will have an answer for me - won't you? ;-)
Anne
----------------------------------------------
This mail sent through http://www.ukonline.net
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
