decimal spaces toolong when mail merging from excel

I recive data in an excel spreadsheet that contains in one column a number 
expressed as " 5.55" which is supposed to be a percentage, but when I try to 
mailmerge the data, it mailmerges as "5.55061561650660". In other words it 
carries out the decimal place more than 2 digits, which is not what I want. I 
have tried formatting the cell, rounding, hand typing the information in 
another column and deleting the column that contained the original 
information (which I am sure was edited from 5.55061561650660.) How can I fix 
this problem so that when I mail merge it comes out as "5.55" only? 
0
punkyh (6)
4/28/2005 5:52:01 AM
excel.newusers 15348 articles. 2 followers. Follow

8 Replies
379 Views

Similar Articles

[PageSpeed] 37

Try tools>options>calculations and select precision as displayed before 
doing the mailmerge

-- 
Regards,

Peo Sjoblom


"punkyh" <punkyh@discussions.microsoft.com> wrote in message 
news:6AC9EF49-22AA-4D40-BBF9-A8E609DE6095@microsoft.com...
>I recive data in an excel spreadsheet that contains in one column a number
> expressed as " 5.55" which is supposed to be a percentage, but when I try 
> to
> mailmerge the data, it mailmerges as "5.55061561650660". In other words it
> carries out the decimal place more than 2 digits, which is not what I 
> want. I
> have tried formatting the cell, rounding, hand typing the information in
> another column and deleting the column that contained the original
> information (which I am sure was edited from 5.55061561650660.) How can I 
> fix
> this problem so that when I mail merge it comes out as "5.55" only? 

0
terre081 (3244)
4/28/2005 6:01:29 AM
Thank you for the quick response! 
I have done this and it still doesn't work.

"Peo Sjoblom" wrote:

> Try tools>options>calculations and select precision as displayed before 
> doing the mailmerge
> 
> -- 
> Regards,
> 
> Peo Sjoblom
> 
> 
> "punkyh" <punkyh@discussions.microsoft.com> wrote in message 
> news:6AC9EF49-22AA-4D40-BBF9-A8E609DE6095@microsoft.com...
> >I recive data in an excel spreadsheet that contains in one column a number
> > expressed as " 5.55" which is supposed to be a percentage, but when I try 
> > to
> > mailmerge the data, it mailmerges as "5.55061561650660". In other words it
> > carries out the decimal place more than 2 digits, which is not what I 
> > want. I
> > have tried formatting the cell, rounding, hand typing the information in
> > another column and deleting the column that contained the original
> > information (which I am sure was edited from 5.55061561650660.) How can I 
> > fix
> > this problem so that when I mail merge it comes out as "5.55" only? 
> 
> 
0
punkyh (6)
4/28/2005 6:10:03 AM
Are you mail-merging into Word? If so, then you have to format the data
within the Word environment.

You will probably find that, in Excel, if you remove all the formatting then
the figures you see are those being merged into Word. It's this "raw" data
that Word sees and acts upon. For anyone using Office 97, how you format
your data in Excel is how Word uses it.

-- 
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"punkyh" <punkyh@discussions.microsoft.com> wrote in message
news:6AC9EF49-22AA-4D40-BBF9-A8E609DE6095@microsoft.com...
> I recive data in an excel spreadsheet that contains in one column a number
> expressed as " 5.55" which is supposed to be a percentage, but when I try
to
> mailmerge the data, it mailmerges as "5.55061561650660". In other words it
> carries out the decimal place more than 2 digits, which is not what I
want. I
> have tried formatting the cell, rounding, hand typing the information in
> another column and deleting the column that contained the original
> information (which I am sure was edited from 5.55061561650660.) How can I
fix
> this problem so that when I mail merge it comes out as "5.55" only?


0
Andy
4/28/2005 7:40:41 AM
How do I do this? 

Thank you for the answer because I was frustrated!

"Andy Wiggins" wrote:

> Are you mail-merging into Word? If so, then you have to format the data
> within the Word environment.
> 
> You will probably find that, in Excel, if you remove all the formatting then
> the figures you see are those being merged into Word. It's this "raw" data
> that Word sees and acts upon. For anyone using Office 97, how you format
> your data in Excel is how Word uses it.
> 
> -- 
> Regards
> -
> Andy Wiggins FCCA
> www.BygSoftware.com
> Excel, Access and VBA Consultancy
> 
> 
> "punkyh" <punkyh@discussions.microsoft.com> wrote in message
> news:6AC9EF49-22AA-4D40-BBF9-A8E609DE6095@microsoft.com...
> > I recive data in an excel spreadsheet that contains in one column a number
> > expressed as " 5.55" which is supposed to be a percentage, but when I try
> to
> > mailmerge the data, it mailmerges as "5.55061561650660". In other words it
> > carries out the decimal place more than 2 digits, which is not what I
> want. I
> > have tried formatting the cell, rounding, hand typing the information in
> > another column and deleting the column that contained the original
> > information (which I am sure was edited from 5.55061561650660.) How can I
> fix
> > this problem so that when I mail merge it comes out as "5.55" only?
> 
> 
> 
0
punkyh (6)
4/28/2005 4:38:02 PM
Add a numeric switch to the field (see "Numeric Picture (\#) field 
switch" in Word Help). For example:

    {MERGEFIELD Field1 \# "0.000" }

In article <0491A03F-7712-42DD-9E8D-87CA8A6A6B6F@microsoft.com>,
 punkyh <punkyh@discussions.microsoft.com> wrote:

> How do I do this? 
> 
> Thank you for the answer because I was frustrated!
> 
> "Andy Wiggins" wrote:
> 
> > Are you mail-merging into Word? If so, then you have to format the data
> > within the Word environment.
0
jemcgimpsey (6723)
4/28/2005 5:10:09 PM
One more question from the novice....

When I do this in word, how do I do it? For example, I do not change the 
data within the Excel Spreadsheet right? 

So, when I open the data within the document, how do I edit the information? 
Or is this even correct? 

Still can't thank you enough. 

"JE McGimpsey" wrote:

> Add a numeric switch to the field (see "Numeric Picture (\#) field 
> switch" in Word Help). For example:
> 
>     {MERGEFIELD Field1 \# "0.000" }
> 
> In article <0491A03F-7712-42DD-9E8D-87CA8A6A6B6F@microsoft.com>,
>  punkyh <punkyh@discussions.microsoft.com> wrote:
> 
> > How do I do this? 
> > 
> > Thank you for the answer because I was frustrated!
> > 
> > "Andy Wiggins" wrote:
> > 
> > > Are you mail-merging into Word? If so, then you have to format the data
> > > within the Word environment.
> 
0
punkyh (6)
4/29/2005 5:34:02 AM
Edit the field in the Word document directly. No need to change anything 
in the XL file.

See "Format merged data" in Word Help.

In article <77060A45-08F5-479A-BB36-6620BC4A2271@microsoft.com>,
 punkyh <punkyh@discussions.microsoft.com> wrote:

> One more question from the novice....
> 
> When I do this in word, how do I do it? For example, I do not change the 
> data within the Excel Spreadsheet right? 
> 
> So, when I open the data within the document, how do I edit the information? 
> Or is this even correct? 
> 
> Still can't thank you enough.
0
jemcgimpsey (6723)
4/29/2005 1:04:50 PM
It works. I tried.

"punkyh" wrote:

> 
> Thank you for the quick response! 
> I have done this and it still doesn't work.
> 
> "Peo Sjoblom" wrote:
> 
> > Try tools>options>calculations and select precision as displayed before 
> > doing the mailmerge
> > 
> > -- 
> > Regards,
> > 
> > Peo Sjoblom
> > 
> > 
> > "punkyh" <punkyh@discussions.microsoft.com> wrote in message 
> > news:6AC9EF49-22AA-4D40-BBF9-A8E609DE6095@microsoft.com...
> > >I recive data in an excel spreadsheet that contains in one column a number
> > > expressed as " 5.55" which is supposed to be a percentage, but when I try 
> > > to
> > > mailmerge the data, it mailmerges as "5.55061561650660". In other words it
> > > carries out the decimal place more than 2 digits, which is not what I 
> > > want. I
> > > have tried formatting the cell, rounding, hand typing the information in
> > > another column and deleting the column that contained the original
> > > information (which I am sure was edited from 5.55061561650660.) How can I 
> > > fix
> > > this problem so that when I mail merge it comes out as "5.55" only? 
> > 
> > 
0
Utf
4/28/2010 8:40:01 PM
Reply:

Similar Artilces:

csv import into excel, preserving leading zeros in numbers
Hi, We have csv file automatically generated where rows look like: "0123","04567","089". The problem is that when Excel opens this file it puts it into cells like 123,456,89 stripping leading zeros. Is there way to generate csv file so that leading zeros won't be stripped so it would like 0123,0456,089 when the file is opened in excel. Thank you Vadim Hi Vadim, rename the file a .txt file. Then you will have a choice for the type of field, number or text -- Kind regards, Niek Otten "Vadim" <vadim@dontsend.com> wrote in message new...

Sending a mail .doc, others see all formatting.
Version: 2004 Operating System: Mac OS X 10.4 (Tiger) When I send a word doc to colleagues they can see all the formatting and editing. I cant see it on my screen nor when I print it out. How can I stoop this? Thanks ...

SOP NonInventory Unit Cost 6 Decimal Places
Is there any simple way to increase the currency decimal places to greater than the current highest value of 5? Thanx Scott, I don't believe there is any easy or even moderately difficult way to do this, as the field types used to store amounts in GP only go up to 5 decimal places. -- Victoria Yudin Dynamics GP MVP Flexible Solutions - home of GP Reports http://www.flex-solutions.com/gpreports.html blog: http://www.victoriayudin.com "Scott Rutledge" <sersoar@hotmail.com> wrote in message news:E102B81B-8555-400E-843C-240C58794294@microsoft.com... > Is there any...

Merge data by macro
Hi all, I got data in column A and B as show below. Row A B ......col 1 ID DATA ...headings 2 XY01 Record 3 Time 4 Left 5 XY02 Time 6 Right 7 XY03 System 8 Record 9 Time 10 Left I need macro which should merge column B data and put result in column C as shown below Row A C ......col 1 ID DATA ...headings 2 XY01 Record Time Left 3 4 5 XY02 Time Right 6 7 XY03 System Record Ti...

search work book in excel 97
how do i search a workbook in excel 97? in excel xp i click the first sheet then shift click the last sheet to select all the sheets, then click find, enter the info and it searches every sheet in the book. I have excel 97 at work and the same procedure only searches the first sheet. is there a different method. in 97 thanks for any help steve Hi this is a change in the later Excel versions. Excel 97 does not support this workbook search.But you may try Jan Karel Pieterse's FLEXFIND.XLA from http://www.bmsltd.ie/mvp/ -- Regards Frank Kabel Frankfurt, Germany Steve Goodrich wrote: &g...

mailbox is full in outlook 2003 but we cant delete the mails
we have the problem in outlook 2003 now no mails arenot downloading and outgoing same time we cant save the mssages when its shows outlook disk is full you cant save the mssage like this same time we cant delete the old mails also please give me reply to solve this problem. awaiting for your reply p vasanth kumar Hi P Vasanth Kumar, have a look on this site: 2gb152.exe: "Specific support tool to create a truncated copy of a .pst file allowing some recovery when the file size has reached over 2 gig" http://www.microsoft.com/downloads/details.aspx?FamilyID=B33B1DFF-6F50-411D-B...

Excel on the web #3
I am trying to put excel worksheets on my website and want visitors to be able to open them as excel. In Netscape only the code appears and in Explorer it opens but in Explorer. The word files open word and the files look fine in both Netscape and Excel. I have tried it on different computers, MAC's, etc. but nothing. Is there a way to do this or have the excel file download? Thanks. I have my users Right Click the mouse button and use the options there. (IE You may be able to look at the MIME area of Internet Explorer and see if you can change how IE reacts. Maybe turn off th...

Public folder does not receive external e-mails
When i send an e-mail to the new public folder with Outlook within the domain, the e-mail arrives. When i send an e-mail manually to the Exchange server, it says the message will be queued: MAIL FROM: <hans> 250 2.1.0 hans@test.nl....Sender OK RCPT TO: <hello@test.nl> 250 2.1.5 hello@test.nl SUBJECT: test 500 5.3.3 Unrecognized command SUBJECT: <test> 500 5.3.3 Unrecognized command DATA 354 Start mail input; end with <CRLF>.<CRLF> SUBJECT: Test Doei .. 250 2.6.0 <ExchangebhsKd6QR7j1HaK00000073@Exchange.test.nl> Queued mail for deli very But it never arr...

using the '&' and keeping the spaces
I'm trying to use the '&' function to assemble a line of data from multiple cells, but i need to have spaces in the line of data for the spots where there is no data in the cooresponding cell. Hi then try =IF(LEN(A1)>=1,A1," ")&" " & IF(LEN(B1)>=1,B1," ") etc Cheers JulieD "durrrant" <durrrant@discussions.microsoft.com> wrote in message news:30BC940D-47FA-420D-9F45-AD649102FCBF@microsoft.com... > I'm trying to use the '&' function to assemble a line of data from > multiple > cells, but ...

Flash cards (Mail merge on 2 sided cards with multiple cards per s
I want to make a set of flash cards (3.5" x 2") with a term on one side and a definition on the back side. I have all the terms and definitions in a spreadsheet. I want to use sheets of tear apart business cards (10 cards per 8.5" x 11" sheet) Each sheet will create 10 flash cards with a unique term on one side and definition on the back side. I understand how to set up a mail merge but if I select “multiple COPIES per sheet” the front and back of the cards are printed properly (definition and the term match) but I get 10 copies of the same card per page. If I s...

Debugging Excel-Start?
Hello, one excel workbook has a very long loading time. How can I see, what excel does? The workbook is several excel-versions old. Maybe that is causing the long loading times. With kind regards Florian Reiser -- http://www.ra-bc.de RA Unternehmensberatung F�hren durch pr�zise Daten This is a multi-part message in MIME format. ------=_NextPart_000_0048_01C6783B.C3047290 Content-Type: text/plain; charset="iso-8859-9" Content-Transfer-Encoding: quoted-printable You can add Stop statement to WorkBook_Open event or AutoOpen procedure. = After that save the workbook, close a...

windows mail
windows mail keeps telling there is an (An unknown error has occurred. Account: 'pop.windstream.net', Server: 'pop.windstream.net', Protocol: POP3, Port: 110, Secure(SSL): No, Error Number: 0x80004005) can any one help i have every tning i can think of in geting this to work end the identities will not work they keep saying imported or delited and can not go now were there eather thank you "Unknown error" is usually caused by interference from an antivirus=20 program. Which antivirus are you running? As a minimum, email scanning in the antivirus should b...

Reduce currency decimals
Hi, Is there any tool which will reduce the currency decimals on our Great Plains system. We want to reduce our system currency decimals. Thank you. KT I'm not sure if this is what you mean, but there's Tools >> Utilities >> Inventory >> Change Decimal Places This utility can change the decimal places for items. I don't know of any system-wide change for decimal places. Eleni "KT" wrote: > Hi, > > Is there any tool which will reduce the currency decimals on our Great > Plains system. We want to reduce our system currency decimals....

2007 outllook junk email message: Junk E-mail [4294967291]
My Junk E-mail folder now reads: Junk E-mail [4294967291] Can't get the [4294967291] to show only the number of any emails in the folder. Have emptied it so there is no emails, but it shows up. The color of the number is as if it is a "read" mail. What is it and how do I get rid of it. Right click on the folder and choose Properties and see if the folder is set to show total number of items or total number of unread items. "Rikki" <Rikki@discussions.microsoft.com> wrote in message news:905125DD-40A3-479B-815D-713E783E9A80@microsoft.com... > My Junk ...

EXCEL.EXE Process Open even though Quit method issued
I'm opening a workbook using the Task Scheduler built-in Windows2000 and when the workbook is done doing what it's supposed to do, I issue an Application.Quit method in the VBA code to close Excel. In the Task Manager, the Excel application (I'm using Excel2000) and the workbook that was opened is not seen in the Application tab, yet there is an EXCEL.EXE in the Processes tab. Also, going in the Task Scheduler, the task itself is still running even though I issued the Quit to get out of Excel. Either stopping the task or ending the process gives me a dump in the Dr.Wat...

Import messages from Windows Mail to Outlook 2002?
I need to switch from Windows Mail to Outlook 2002. I have been able to export and import contacts and calendars, but can't see how to export messages or groups from Mail. Do I have to upgrade to a later Outlook? If you want to use a supported version of Outlook, then yes, you'll need to upgrade to either Outlook 2003 or Outlook 2007. Outlook 2002 has known compatibility issues with Windows Vista which will not be addressed since Outlook 2002 is out of mainstream support for quite some time now. One of the most notable issues is that Outlook will not remember you passwo...

decimal problem
Hi all I a very strange effect when using different decimal settings and calculating some values: DECLARE @Decimal1 decimal(5, 2) DECLARE @Decimal2 decimal(30, 2) SET @Decimal1 = 0.2 SET @Decimal2 = 0.2 SELECT (CONVERT(decimal(15, 15), 0.000000000322900) * (1 - @Decimal1)) SELECT (CONVERT(decimal(15, 15), 0.000000000322900) * (1 - @Decimal2)) The first result is correct (0.00000000025832000), the second is wrong, why ??? Thanks for any comments Best regards Frank Uray Hi Frank This is what happens when you multiple these precision&scales Precision 15 + 3...

Sync multiple e-mail accounts
I run Outlook 2007 and Windows Mobile 6. How do I get my contacts and calendar to syncronize between my phone and two e-mail accounts on my computer (G-mail and kiwilink)? "Need to Sync" <Need to Sync@discussions.microsoft.com> wrote in message news:2ED27720-6208-41A4-BED3-F875E32D4FEB@microsoft.com... >I run Outlook 2007 and Windows Mobile 6. How do I get my contacts and > calendar to syncronize between my phone and two e-mail accounts on my > computer (G-mail and kiwilink)? Google Sync should work for gmail. I have no idea what "kiwilink"...

Decimal
In a laboratory test we do the temperature has to be reported to the nearest 0.5�C. Can anyone let me know how to format it so that when the result is a whole number, it leaves the decimal point out? eg 22�C or 22.5�C (not 22.�C or 22.0�C) Alan "Alan Cocks" <alandrob@netspace.net.au> wrote in message news:btlqhd$19fi$1@otis.netspace.net.au... > In a laboratory test we do the temperature has to be reported to the > nearest 0.5�C. > Can anyone let me know how to format it so that when the result is a whole > number, it leaves the decimal point out? &g...

How to create macro to e-mail a form?
I have created a Form in Word 2007 containing blanks to be filled in by an applicant and then e-mailed. To facilitate the application process I am trying to create a macro to allow the applicant to do the following with one click of the mouse: 1. SAVE the just completed form 2. OPEN an e-mail to an address specified in the form 3. ATTACH the completed form to the e-mail 4. SEND the e-mail Can anyone help? Thanks, See http://www.word.mvps.org/FAQs/InterDev/SendMail.htm -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowled...

history of excel
does any body knows the history of excel Hi maybe this is of interest for you: http://j-walk.com/ss/history/index.htm -- Regards Frank Kabel Frankfurt, Germany mixtecos@hotmail.com wrote: > does any body knows the history of excel Hi A web search in google using " excel+history " would be a good starting point. (670,000 answers) HTH Regards Bob C. >-----Original Message----- >does any body knows the history of excel > >. > ...

Unique Excel records only
Hello: I am using Excel 2003, and I have three columns of data. Some of the records of each of the three columns (a) have spaces between them and (b) have duplicates. Is there a way to pull out the spaces (i.e. the blank records) and eliminate the duplicate records? In an attempt to filter out the duplicates, I went to Data...Advanced Sort and checked the box "Unique records only". But, that was not correct. Some duplicates and at least one blank record remained. Any help on this would be thoroughly appreciated. Thanks. childofthe1980s "I went to Data...Advanced S...

excel 2002 files not saved
When a file is created in excel and is saved. When I want to check the file it is not there but there is one file with alphanumeric number with extension file which is my excel file. looks like it is the temp file. can this problem be avoided so that it keeps the file with the given name. When you save a file, excel will save it as a temporary file (8 characters, no extension). Then if that save is successful, excel will delete the original and rename this funny named file to the original's name. You see the results when something interferes with this process. A couple of things th...

Outlook freezes after clicking on e-mail
We have a user who just started having a problem with Outlook 2002. They click on an e-mail and then go to click on another e-mail and Outlook freezes. She just gets the hourglass and parts of the screen goes black. Any ideas as to what is happening and how do we fix it? Thanks, David ...

How do I remove spaces at the beginning of cells?
I have a column of names I need to sort. Unfortunately, some of the cells have 1 or 2 leading spaces, which cause the zero-leading spaces to be sorted, then the one-leading space, then two-leading space. And since there are over 3000 names to be sorted, doing them by hand is problematic. One way... Use a temporary helper column and enter a formula like this: =TRIM(A1) Copy that formula down as far as needed. Then, select the entire range of formulas and do: Right click>Copy Right click>Paste Special>Values>OK Compare the 2 columns and make sure the helpe...