How do I keep leading zeros from an Excel file that I upload into Smartsheets?
When I upload an Excel file into Smartsheets any formatting I have for numbers does not carry over. For instance, I have 6-digit stores numbers where the first several digits begin with a Zero (the same with zip codes) and it drops those "leading zeros". Also, I have formatting for phone numbers and it drops the parenthesis and the hyphens.
I have to constantly go back and copy and paste that information into the sheet which defeats the whole purpose of uploading the file from Excel.
Is there another way to keep the formatting? Is there a specific format in Excel I should be using to maintain that information? I really want to avoid manually copying and pasting information as that opens us up for a lot of human error.
Is this a problem that Data Shuttle could solve?