Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Word is adding zeros in front of numbers
I have Office 2003 and am attempting to merge MSExcel data into a Word
document. I have been working through the problems associated with formats, however, there is one that I can't seem to resolve. Sometimes the merged numerics that appear in MSWord have a zero in front of the number, e.g. 056 or -078. This only occurs when the actual number in the Excel spreadsheet is less than 100 and also only seems to occur when the data in Excel is the result of a formula, e.g. "=A3+B3". When data is merely entered as a numeric value, e.g. 57, it appears as 57 in Word, not 057. Suggestions would be helpful. Thank you |
#2
|
|||
|
|||
This may help, Nat:
http://www.officearticles.com/word/m...osoft_word.htm ******************* ~Anne Troy www.OfficeArticles.com "Nat" wrote in message ... I have Office 2003 and am attempting to merge MSExcel data into a Word document. I have been working through the problems associated with formats, however, there is one that I can't seem to resolve. Sometimes the merged numerics that appear in MSWord have a zero in front of the number, e.g. 056 or -078. This only occurs when the actual number in the Excel spreadsheet is less than 100 and also only seems to occur when the data in Excel is the result of a formula, e.g. "=A3+B3". When data is merely entered as a numeric value, e.g. 57, it appears as 57 in Word, not 057. Suggestions would be helpful. Thank you |
#3
|
|||
|
|||
Thank you for the response Anne, but it doesn't quite get at my problem. My
problem is that the merge feature is ADDING a zero in fron of some numbers - not dropping them. I think that I could include a switch that limits the number of digits to the LEFT of a decimal point - thus eliminating the zero, but this will not allow that merged item to include three digit numbers when needed. What I need is a solution to get RID of a leading zero - not add leading zeros. Thanks "Anne Troy" wrote: This may help, Nat: http://www.officearticles.com/word/m...osoft_word.htm ******************* ~Anne Troy www.OfficeArticles.com "Nat" wrote in message ... I have Office 2003 and am attempting to merge MSExcel data into a Word document. I have been working through the problems associated with formats, however, there is one that I can't seem to resolve. Sometimes the merged numerics that appear in MSWord have a zero in front of the number, e.g. 056 or -078. This only occurs when the actual number in the Excel spreadsheet is less than 100 and also only seems to occur when the data in Excel is the result of a formula, e.g. "=A3+B3". When data is merely entered as a numeric value, e.g. 57, it appears as 57 in Word, not 057. Suggestions would be helpful. Thank you |
#4
|
|||
|
|||
Okay, Nat. So what does your merge field look like when you view it? Also,
what's the cell format in Excel? ******************* ~Anne Troy www.OfficeArticles.com "Nat" wrote in message ... Thank you for the response Anne, but it doesn't quite get at my problem. My problem is that the merge feature is ADDING a zero in fron of some numbers - not dropping them. I think that I could include a switch that limits the number of digits to the LEFT of a decimal point - thus eliminating the zero, but this will not allow that merged item to include three digit numbers when needed. What I need is a solution to get RID of a leading zero - not add leading zeros. Thanks "Anne Troy" wrote: This may help, Nat: http://www.officearticles.com/word/m...osoft_word.htm ******************* ~Anne Troy www.OfficeArticles.com "Nat" wrote in message ... I have Office 2003 and am attempting to merge MSExcel data into a Word document. I have been working through the problems associated with formats, however, there is one that I can't seem to resolve. Sometimes the merged numerics that appear in MSWord have a zero in front of the number, e.g. 056 or -078. This only occurs when the actual number in the Excel spreadsheet is less than 100 and also only seems to occur when the data in Excel is the result of a formula, e.g. "=A3+B3". When data is merely entered as a numeric value, e.g. 57, it appears as 57 in Word, not 057. Suggestions would be helpful. Thank you |
#5
|
|||
|
|||
Hi Anne.
My goal is for the merged data to appear as numbers that look something like 2,300, 75, etc. The dilemma is that, thus far, I have not been able to achieve that outcome using switch codes - it seems that I must sacrifice one of three things. First, when using a switch code "\#0" I can obtain the desired effect, but no commas are present. If I use "\#,#" then mergefields for which the data source reports a zero are ommitted in the merged document. If I use "\#0 #,#" then no commas appear. If I modify slightly by "\#0#,#" I get my zeros and commas, but data in the MSExcel document that are the product of a formula, e.g. "=sum(A1:A4)" AND are less than three digits, e.g. 45, are presented as "045." Thus far, I have not been able to find the right combination of switches that will give me: commas, viewable data-source zero-value-entries, AND properly formatted merge results, e.g. 45, that is the product of a formula in the source document. I simply don't know what other switches or solutions might be available. Thank you for any assistance or solution you might be able to provide. Nat If I want the commas then I have to accept numbers like "075." Alternatively, I can get the number to look like "75" but then I can't get the commas. And yet another alternative, I can indeed get the commas and the two digit numbers looking right, but I will lose other merged values for which a zero is entered in the spreadsheet. I am using an MSExcel file as the source document and merging to an MSWrod document. The situation occurs for a couple of cells, all with the same structure. First, the MSExcel content is the result of a formula, e.g. "=sum(s3:s9)." Second, result of the formula is a two digit number, e.g. 59. When the number is three digits there is no problem. In the MSWord document, an example of a problematic merge field (when viewed with the F9 toggle) is { MERGEFIELD "Total_Revenue" }. The result looks something like "059." I have tried a couple of switches in hopes of getting the appearance I want but can never get every thing I want. For example, { MERGEFIELD "Total_Revenue" \#0 } gives "59," but when I try to include a switch that will format using commas in larger numbers { MERGEFIELD "Total_Revenue" \#0 #,#} it goes back to "059." solutions but I have not been able to get the "Anne Troy" wrote: Okay, Nat. So what does your merge field look like when you view it? Also, what's the cell format in Excel? ******************* ~Anne Troy www.OfficeArticles.com "Nat" wrote in message ... Thank you for the response Anne, but it doesn't quite get at my problem. My problem is that the merge feature is ADDING a zero in fron of some numbers - not dropping them. I think that I could include a switch that limits the number of digits to the LEFT of a decimal point - thus eliminating the zero, but this will not allow that merged item to include three digit numbers when needed. What I need is a solution to get RID of a leading zero - not add leading zeros. Thanks "Anne Troy" wrote: This may help, Nat: http://www.officearticles.com/word/m...osoft_word.htm ******************* ~Anne Troy www.OfficeArticles.com "Nat" wrote in message ... I have Office 2003 and am attempting to merge MSExcel data into a Word document. I have been working through the problems associated with formats, however, there is one that I can't seem to resolve. Sometimes the merged numerics that appear in MSWord have a zero in front of the number, e.g. 056 or -078. This only occurs when the actual number in the Excel spreadsheet is less than 100 and also only seems to occur when the data in Excel is the result of a formula, e.g. "=A3+B3". When data is merely entered as a numeric value, e.g. 57, it appears as 57 in Word, not 057. Suggestions would be helpful. Thank you |
#6
|
|||
|
|||
Did you try \#,0
? Peter Jamieson "Nat" wrote in message ... Hi Anne. My goal is for the merged data to appear as numbers that look something like 2,300, 75, etc. The dilemma is that, thus far, I have not been able to achieve that outcome using switch codes - it seems that I must sacrifice one of three things. First, when using a switch code "\#0" I can obtain the desired effect, but no commas are present. If I use "\#,#" then mergefields for which the data source reports a zero are ommitted in the merged document. If I use "\#0 #,#" then no commas appear. If I modify slightly by "\#0#,#" I get my zeros and commas, but data in the MSExcel document that are the product of a formula, e.g. "=sum(A1:A4)" AND are less than three digits, e.g. 45, are presented as "045." Thus far, I have not been able to find the right combination of switches that will give me: commas, viewable data-source zero-value-entries, AND properly formatted merge results, e.g. 45, that is the product of a formula in the source document. I simply don't know what other switches or solutions might be available. Thank you for any assistance or solution you might be able to provide. Nat If I want the commas then I have to accept numbers like "075." Alternatively, I can get the number to look like "75" but then I can't get the commas. And yet another alternative, I can indeed get the commas and the two digit numbers looking right, but I will lose other merged values for which a zero is entered in the spreadsheet. I am using an MSExcel file as the source document and merging to an MSWrod document. The situation occurs for a couple of cells, all with the same structure. First, the MSExcel content is the result of a formula, e.g. "=sum(s3:s9)." Second, result of the formula is a two digit number, e.g. 59. When the number is three digits there is no problem. In the MSWord document, an example of a problematic merge field (when viewed with the F9 toggle) is { MERGEFIELD "Total_Revenue" }. The result looks something like "059." I have tried a couple of switches in hopes of getting the appearance I want but can never get every thing I want. For example, { MERGEFIELD "Total_Revenue" \#0 } gives "59," but when I try to include a switch that will format using commas in larger numbers { MERGEFIELD "Total_Revenue" \#0 #,#} it goes back to "059." solutions but I have not been able to get the "Anne Troy" wrote: Okay, Nat. So what does your merge field look like when you view it? Also, what's the cell format in Excel? ******************* ~Anne Troy www.OfficeArticles.com "Nat" wrote in message ... Thank you for the response Anne, but it doesn't quite get at my problem. My problem is that the merge feature is ADDING a zero in fron of some numbers - not dropping them. I think that I could include a switch that limits the number of digits to the LEFT of a decimal point - thus eliminating the zero, but this will not allow that merged item to include three digit numbers when needed. What I need is a solution to get RID of a leading zero - not add leading zeros. Thanks "Anne Troy" wrote: This may help, Nat: http://www.officearticles.com/word/m...osoft_word.htm ******************* ~Anne Troy www.OfficeArticles.com "Nat" wrote in message ... I have Office 2003 and am attempting to merge MSExcel data into a Word document. I have been working through the problems associated with formats, however, there is one that I can't seem to resolve. Sometimes the merged numerics that appear in MSWord have a zero in front of the number, e.g. 056 or -078. This only occurs when the actual number in the Excel spreadsheet is less than 100 and also only seems to occur when the data in Excel is the result of a formula, e.g. "=A3+B3". When data is merely entered as a numeric value, e.g. 57, it appears as 57 in Word, not 057. Suggestions would be helpful. Thank you |
#7
|
|||
|
|||
That's the answer! Thank you Peter!
"Peter Jamieson" wrote: Did you try \#,0 ? Peter Jamieson "Nat" wrote in message ... Hi Anne. My goal is for the merged data to appear as numbers that look something like 2,300, 75, etc. The dilemma is that, thus far, I have not been able to achieve that outcome using switch codes - it seems that I must sacrifice one of three things. First, when using a switch code "\#0" I can obtain the desired effect, but no commas are present. If I use "\#,#" then mergefields for which the data source reports a zero are ommitted in the merged document. If I use "\#0 #,#" then no commas appear. If I modify slightly by "\#0#,#" I get my zeros and commas, but data in the MSExcel document that are the product of a formula, e.g. "=sum(A1:A4)" AND are less than three digits, e.g. 45, are presented as "045." Thus far, I have not been able to find the right combination of switches that will give me: commas, viewable data-source zero-value-entries, AND properly formatted merge results, e.g. 45, that is the product of a formula in the source document. I simply don't know what other switches or solutions might be available. Thank you for any assistance or solution you might be able to provide. Nat If I want the commas then I have to accept numbers like "075." Alternatively, I can get the number to look like "75" but then I can't get the commas. And yet another alternative, I can indeed get the commas and the two digit numbers looking right, but I will lose other merged values for which a zero is entered in the spreadsheet. I am using an MSExcel file as the source document and merging to an MSWrod document. The situation occurs for a couple of cells, all with the same structure. First, the MSExcel content is the result of a formula, e.g. "=sum(s3:s9)." Second, result of the formula is a two digit number, e.g. 59. When the number is three digits there is no problem. In the MSWord document, an example of a problematic merge field (when viewed with the F9 toggle) is { MERGEFIELD "Total_Revenue" }. The result looks something like "059." I have tried a couple of switches in hopes of getting the appearance I want but can never get every thing I want. For example, { MERGEFIELD "Total_Revenue" \#0 } gives "59," but when I try to include a switch that will format using commas in larger numbers { MERGEFIELD "Total_Revenue" \#0 #,#} it goes back to "059." solutions but I have not been able to get the "Anne Troy" wrote: Okay, Nat. So what does your merge field look like when you view it? Also, what's the cell format in Excel? ******************* ~Anne Troy www.OfficeArticles.com "Nat" wrote in message ... Thank you for the response Anne, but it doesn't quite get at my problem. My problem is that the merge feature is ADDING a zero in fron of some numbers - not dropping them. I think that I could include a switch that limits the number of digits to the LEFT of a decimal point - thus eliminating the zero, but this will not allow that merged item to include three digit numbers when needed. What I need is a solution to get RID of a leading zero - not add leading zeros. Thanks "Anne Troy" wrote: This may help, Nat: http://www.officearticles.com/word/m...osoft_word.htm ******************* ~Anne Troy www.OfficeArticles.com "Nat" wrote in message ... I have Office 2003 and am attempting to merge MSExcel data into a Word document. I have been working through the problems associated with formats, however, there is one that I can't seem to resolve. Sometimes the merged numerics that appear in MSWord have a zero in front of the number, e.g. 056 or -078. This only occurs when the actual number in the Excel spreadsheet is less than 100 and also only seems to occur when the data in Excel is the result of a formula, e.g. "=A3+B3". When data is merely entered as a numeric value, e.g. 57, it appears as 57 in Word, not 057. Suggestions would be helpful. Thank you |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does Word have Keyboard Merges like Word Perfect does? | Mailmerge | |||
Word2000 letterhead merge | Mailmerge | |||
Underscore (_) will not always display in RTF files (Word 2002). | Microsoft Word Help | |||
creating forms | Microsoft Word Help | |||
How do I create & merge specific data base & master documents? | New Users |