Issues with Importing and/or Copy/Pasting in Numbers
I am having a bit of a challenge with bringing numbers into smartsheet, and its an issue that isn't constant across all of my sheets which is what has me stumped.
I need to copy/past in numbers each week to (2) different sheets from (2) different excel sources.
When I copy/paste in from excel sheet #1, the numbers populate in as shown below, with an apostrophe in front of the number (which you can only see when you double click on the cell) which breaks my formulas. When I copy/paste in from the excel sheet #2, everything shows up just fine.
How can I remove the apostrophe in front of the numbers when I'm copy/pasting them in? I've tried changing the data in excel to Text, General, Number, etc and nothing seems to make a difference. Right now, I am having to go in and manually delete the apostrophe which isn't sustainable.
Thank you in advance for the assistance!
Help Article Resources
Check out the Formula Handbook template!