D
danhattan
Using Excel and Word 2003.
Our Word document populates with data entered into an Excel spreadsheet.
Part of the data includes account numbers, often longer than 15 digits. We're
aware that Excel changes every digit after the 15th to a zero if the cell is
formatted as a number. We can actually live with that for our purposes.
The problem is that the Word document wants to convert these long numbers
into scientific notation so that there's a decimal point after the first
digit and an "E+16" tacked onto the end.
Is there a way to prevent this so that the number displays in Word as it
does in Excel? I tried using the Arabic switch, but it generates an error
saying the number cannot be represented in that format.
Any help would be greatly appreciated. Thanks in advance.
Our Word document populates with data entered into an Excel spreadsheet.
Part of the data includes account numbers, often longer than 15 digits. We're
aware that Excel changes every digit after the 15th to a zero if the cell is
formatted as a number. We can actually live with that for our purposes.
The problem is that the Word document wants to convert these long numbers
into scientific notation so that there's a decimal point after the first
digit and an "E+16" tacked onto the end.
Is there a way to prevent this so that the number displays in Word as it
does in Excel? I tried using the Arabic switch, but it generates an error
saying the number cannot be represented in that format.
Any help would be greatly appreciated. Thanks in advance.