Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge fields from excel are formating with too many decimal positi
I have a field in excel that has 7.55 but the mail merge is showing it as
7.5499999999998. the cell in excel only has the value of 7.55 and I have tried formating it as number, currency with 2 decimals and does not make a difference. it happens on several lines but not all lines |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge fields from excel are formating with too many decimal positi
Word pulls the VALUE, not the VIEW of the cell. Click on the cell and look
at the formula bar. THAT is what Word will pull. See this article to fix it; should only take a few moments: http://www.officearticles.com/word/m...osoft_word.htm ************ Hope it helps! Anne Troy www.OfficeArticles.com "Roger Smith" Roger wrote in message ... I have a field in excel that has 7.55 but the mail merge is showing it as 7.5499999999998. the cell in excel only has the value of 7.55 and I have tried formating it as number, currency with 2 decimals and does not make a difference. it happens on several lines but not all lines |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge fields from excel are formating with too many decimal po
the value was 7.55 in the formula bar. But I did already find an article
about switches and I was able to fix it with \###.##. thanks for your response "Anne Troy" wrote: Word pulls the VALUE, not the VIEW of the cell. Click on the cell and look at the formula bar. THAT is what Word will pull. See this article to fix it; should only take a few moments: http://www.officearticles.com/word/m...osoft_word.htm ************ Hope it helps! Anne Troy www.OfficeArticles.com "Roger Smith" Roger wrote in message ... I have a field in excel that has 7.55 but the mail merge is showing it as 7.5499999999998. the cell in excel only has the value of 7.55 and I have tried formating it as number, currency with 2 decimals and does not make a difference. it happens on several lines but not all lines |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge fields from excel are formating with too many decimal po
You're welcome.
************ Hope it helps! Anne Troy www.OfficeArticles.com "Roger Smith" wrote in message ... the value was 7.55 in the formula bar. But I did already find an article about switches and I was able to fix it with \###.##. thanks for your response "Anne Troy" wrote: Word pulls the VALUE, not the VIEW of the cell. Click on the cell and look at the formula bar. THAT is what Word will pull. See this article to fix it; should only take a few moments: http://www.officearticles.com/word/m...osoft_word.htm ************ Hope it helps! Anne Troy www.OfficeArticles.com "Roger Smith" Roger wrote in message ... I have a field in excel that has 7.55 but the mail merge is showing it as 7.5499999999998. the cell in excel only has the value of 7.55 and I have tried formating it as number, currency with 2 decimals and does not make a difference. it happens on several lines but not all lines |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word merge field names vs. Excel merge field names | Mailmerge | |||
Mail Merge: Excel (XP) fields scrambled during merge | Mailmerge | |||
Mail Merge w/ Excel Data | Microsoft Word Help | |||
Mail merge prints out incorrect no. of decimal places from Excel . | Mailmerge | |||
How do I merge an excel document | Tables |