Forum Discussion
Strange Paste Problem
Mike952 .... For data entry, Excel interprets up to only the first 15 significant digits, replacing any digits to the right with zeros. Moreover, when displaying numeric values, Excel formats up to only the first 15 significant digits, rounded, replacing any digits to the right with zeros.
You need to enter your data as text. Ostensibly, we should be able to make the cell format Text, then paste into. However, I'm not sure that is sufficient to override Excel's behavior, especially when the source is MSWord. Alternatively, we could prefix __each__ data value with an apostrophe (single quote). But of course, we can do that only one-by-one, not when pasting a column of "numeric" text, for example.
My approach is: paste into Notepad and save the "txt" file. Then __import__ the file into Excel using Data > Get External Data > From Text. In the last (third) dialog box of the Import Text Wizard, select the column(?) of data, then select Column Data Format > Text.
Errata: It is sufficient to paste the data into Notepad first. Then in Excel, format the cells as Text first, then copy-and-paste from Notepad directly into Excel. No need to save as a "txt" file first.
But note that any "numeric" text entered that way will lose precision on the right if you try to reference the data in numeric expressions.
- Mike952Dec 17, 2021Copper Contributor
JoeUser2004 Thank you for the suggestion !!! We found a similar workaround using the "text" idea. Since we did not have to use the number in a formula, we added a alpha prefix (followed by a hyphen) to the number (formatted as text) and that change allowed the cell entry/paste without Excel auto-changing the what got pasted into the cell.