Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Debs Debs is offline
external usenet poster
 
Posts: 12
Default Displaying Two Decimal Places in Merged Excel Data

Hi

I would like to merge numerical data from Excel which has been formatted as
£1,000.10 in a Word doc. When I do this however in the Word doc it does not
display .10 but .1 even though it has been formatted in Excel to show two
characters after the decimal Point?

Any help most appreciated!

Debs
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Displaying Two Decimal Places in Merged Excel Data

The formatting in Excel is irrelevant. Add a formatting switch to the Word
field

{Mergefield Fieldname \# ",0.00" }

see http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

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


Debs wrote:
Hi

I would like to merge numerical data from Excel which has been
formatted as 1,000.10 in a Word doc. When I do this however in the
Word doc it does not display .10 but .1 even though it has been
formatted in Excel to show two characters after the decimal Point?

Any help most appreciated!

Debs



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Debs Debs is offline
external usenet poster
 
Posts: 12
Default Displaying Two Decimal Places in Merged Excel Data

Many thanks for you help Graham it works perfectly!

Debs

"Graham Mayor" wrote:

The formatting in Excel is irrelevant. Add a formatting switch to the Word
field

{Mergefield Fieldname \# "£,0.00" }

see http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

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


Debs wrote:
Hi

I would like to merge numerical data from Excel which has been
formatted as £1,000.10 in a Word doc. When I do this however in the
Word doc it does not display .10 but .1 even though it has been
formatted in Excel to show two characters after the decimal Point?

Any help most appreciated!

Debs




  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Displaying Two Decimal Places in Merged Excel Data

You are welcome

--

Graham Mayor - Word MVP

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



Debs wrote:
Many thanks for you help Graham it works perfectly!

Debs

"Graham Mayor" wrote:

The formatting in Excel is irrelevant. Add a formatting switch to
the Word field

{Mergefield Fieldname \# ",0.00" }

see http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

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


Debs wrote:
Hi

I would like to merge numerical data from Excel which has been
formatted as 1,000.10 in a Word doc. When I do this however in the
Word doc it does not display .10 but .1 even though it has been
formatted in Excel to show two characters after the decimal Point?

Any help most appreciated!

Debs



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
taking data from excel and displaying it in word campoone Microsoft Word Help 1 November 8th 06 04:51 PM
merge data from excel puts too many decimal values on my template. cary Mailmerge 1 August 21st 06 08:00 PM
Unwanted decimal places in a mail merge from Excel Kurch Mailmerge 1 May 15th 06 10:18 PM
Too many decimal places Chris Knigge Mailmerge 1 April 13th 05 05:19 AM
Mail merge prints out incorrect no. of decimal places from Excel . UDDWF Mailmerge 1 February 7th 05 11:22 PM


All times are GMT +1. The time now is 08:41 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"