Forum Discussion
Preserve cell formatting
I'm using an excel sheet to upload into another system. Different users are using these upload sheets and these sheets contain large data records (up to 100k). There is a column which represents the ...
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
