 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / June 2007Excel and 15+ digit numbers
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. How are your account number cells formattedi n Excel? If it isn't "text", is there a reason why you cannot format as text? If it is "text" a. Is the whole column formatted that way? b. can you back up your sheet, select the column, then use the Data|Text to columns option and in step 3, select the "Text" data format, then Finish. Does that make any difference? Are you using these account numbers in any way within Word except as a simple { MERGEFIELD accountno } field? Peter Jamieson > Using Excel and Word 2003. > [quoted text clipped - 14 lines] > > Any help would be greatly appreciated. Thanks in advance. Just tried that and it worked perfectly. In all the years I've used Excel I've never had cause to format a cell as text, and not sure I even realized it was an option. Our people are populating that column by pasting from another application, and I wanted to avoid requiring them to type an apostrophe prior to the paste, so this works very well. Thanks much for all the help you provide. I try to search for previous similar questions before adding a redundant post and you've been unknowingly helpful to me many times. Dan > How are your account number cells formattedi n Excel? If it isn't "text", is > there a reason why you cannot format as text? [quoted text clipped - 28 lines] > > > > Any help would be greatly appreciated. Thanks in advance.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.