Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Francis Francis is offline
external usenet poster
 
Posts: 7
Default Limit merge to 2 decimal place

I am merging data from excel spreadsheet into a form in Word. The form has
cells in it that were create in excel.
The column of numbers in source excel is formated to 2 decimal places. When
I merge data into the word document cells, the number extends out to 15
places.
I have tried reducing the cell size, but the cell expands when i merge the
data.


3 To 10 Days
55.550000000000004


  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Limit merge to 2 decimal place

Use Alt-F9 in Word to show the field codes, then change e.g.

{ MERGEFIELD mynumber }
to
{ MERGEFIELD mynumber \#0.00 }

(you can usually get rid of " \*Mergeformat " if you see that)

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Francis" wrote in message
...
I am merging data from excel spreadsheet into a form in Word. The form has
cells in it that were create in excel.
The column of numbers in source excel is formated to 2 decimal places.
When
I merge data into the word document cells, the number extends out to 15
places.
I have tried reducing the cell size, but the cell expands when i merge the
data.


3 To 10 Days
55.550000000000004



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Francis Francis is offline
external usenet poster
 
Posts: 7
Default Limit merge to 2 decimal place

thanks for your help, but it is still there.

"Peter Jamieson" wrote:

Use Alt-F9 in Word to show the field codes, then change e.g.

{ MERGEFIELD mynumber }
to
{ MERGEFIELD mynumber \#0.00 }

(you can usually get rid of " \*Mergeformat " if you see that)

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Francis" wrote in message
...
I am merging data from excel spreadsheet into a form in Word. The form has
cells in it that were create in excel.
The column of numbers in source excel is formated to 2 decimal places.
When
I merge data into the word document cells, the number extends out to 15
places.
I have tried reducing the cell size, but the cell expands when i merge the
data.


3 To 10 Days
55.550000000000004




  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Limit merge to 2 decimal place

Update the field after making the change - F9

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Francis wrote:
thanks for your help, but it is still there.

"Peter Jamieson" wrote:

Use Alt-F9 in Word to show the field codes, then change e.g.

{ MERGEFIELD mynumber }
to
{ MERGEFIELD mynumber \#0.00 }

(you can usually get rid of " \*Mergeformat " if you see that)

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Francis" wrote in message
...
I am merging data from excel spreadsheet into a form in Word. The
form has cells in it that were create in excel.
The column of numbers in source excel is formated to 2 decimal
places. When
I merge data into the word document cells, the number extends out
to 15 places.
I have tried reducing the cell size, but the cell expands when i
merge the data.


3 To 10 Days
55.550000000000004



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mergering excel to word the decimal place set in excel is gone Maria Microsoft Word Help 1 January 8th 08 01:45 PM
Limit the number of decimal places shown when I merge Excel-Word Bill W Mailmerge 1 January 8th 08 01:28 AM
Getting Decimal Point With Mail Merge Bethesda CPA Mailmerge 1 November 10th 06 04:40 AM
Limit decimal places in mail merge document Diana Corl Mailmerge 2 September 28th 05 02:13 PM
merge field numbering/decimal place problem gremlinsgimi Mailmerge 1 April 9th 05 09:40 AM


All times are GMT +1. The time now is 03:17 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"