A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

decimal spaces toolong when mail merging from excel



 
 
Thread Tools Display Modes
  #1  
Old April 28th, 2005, 06:52 AM
punkyh
external usenet poster
 
Posts: n/a
Default 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?
  #2  
Old April 28th, 2005, 07:01 AM
Peo Sjoblom
external usenet poster
 
Posts: n/a
Default

Try toolsoptionscalculations and select precision as displayed before
doing the mailmerge

--
Regards,

Peo Sjoblom


"punkyh" wrote in message
...
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?


  #3  
Old April 28th, 2005, 07:10 AM
punkyh
external usenet poster
 
Posts: n/a
Default


Thank you for the quick response!
I have done this and it still doesn't work.

"Peo Sjoblom" wrote:

Try toolsoptionscalculations and select precision as displayed before
doing the mailmerge

--
Regards,

Peo Sjoblom


"punkyh" wrote in message
...
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?



  #4  
Old April 28th, 2005, 08:40 AM
Andy Wiggins
external usenet poster
 
Posts: n/a
Default

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" wrote in message
...
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?



  #5  
Old April 28th, 2005, 05:38 PM
punkyh
external usenet poster
 
Posts: n/a
Default

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" wrote in message
...
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?




  #6  
Old April 28th, 2005, 06:10 PM
JE McGimpsey
external usenet poster
 
Posts: n/a
Default

Add a numeric switch to the field (see "Numeric Picture (\#) field
switch" in Word Help). For example:

{MERGEFIELD Field1 \# "0.000" }

In article ,
punkyh 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.

  #7  
Old April 29th, 2005, 06:34 AM
punkyh
external usenet poster
 
Posts: n/a
Default

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 ,
punkyh 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.


  #8  
Old April 29th, 2005, 02:04 PM
JE McGimpsey
external usenet poster
 
Posts: n/a
Default

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 ,
punkyh 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.

  #9  
Old April 28th, 2010, 09:40 PM posted to microsoft.public.excel.newusers
TimW
external usenet poster
 
Posts: 4
Default decimal spaces toolong when mail merging from excel

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 toolsoptionscalculations and select precision as displayed before
doing the mailmerge

--
Regards,

Peo Sjoblom


"punkyh" wrote in message
...
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?



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to measure the distance between two lat and long points A new kind of measurement Running & Setting Up Queries 6 January 14th, 2005 05:45 PM
How do I get the "0" to print in the zip code when mail merging f. Ragmop General Discussion 4 January 11th, 2005 09:51 PM
Decimal points on an excel mail merge Wishart1 Mailmerge 1 November 12th, 2004 01:05 AM
mail merge calculated numbers from Excel to two decimal places? Mike1411 Mailmerge 1 September 14th, 2004 03:44 PM
controlling number of decimal spaces displayed ChuckM Worksheet Functions 1 December 18th, 2003 08:36 PM


All times are GMT +1. The time now is 11:58 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.