Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
taking data from excel and displaying it in word | Microsoft Word Help | |||
merge data from excel puts too many decimal values on my template. | Mailmerge | |||
Unwanted decimal places in a mail merge from Excel | Mailmerge | |||
Too many decimal places | Mailmerge | |||
Mail merge prints out incorrect no. of decimal places from Excel . | Mailmerge |