Forum Discussion
Preserve cell formatting
This https://superuser.com/questions/413226/why-does-excel-treat-long-numeric-strings-as-scientific-notation-even-after-chan explains why it happens. The best way to bypass this is to insert an apostrophe in front of numbers to convert it to a text (https://www.excelhow.net/how-to-insert-hidden-apostrophe-in-front-of-numbers-to-make-number-convert-to-text-format-in-excel.html)
Thx for the feedback. It places the apostrophe in front which is now seen by excel as a character. When importing into our target application, it now imports the apostrophe as a character into the target tables. Hopefully in the future this will be solved through a standard excel feature.
To remove single quote in front of numbers in a cell, you can highlight the entire column where the pasted text figure will be and Clear Formatting.
Go to Home Tab > Editing Group> Clear > Clear Formatting
