Leading zeroes for importing from Excel on Sharepoint
I am trying to import an Excel spreadsheet from
a Sharepoint Site as a data set. There
are 4 columns with leading zeroes that are formatted as Text. They are being imported as numbers which
really messes up the data set. I don’t
know if this makes a difference or not but the cell value in the spreadsheet
itself is a formula driven field and is not constant. Is there a work around for this?
Still not going to work. Some of these codes need to be 6 characters, some 8 and some 9. There is nothing in the data set to tell us which is which and the Excel formula does it for us. That is why we need to have the leading zeroes brought in. To me, Paxata should allow us to tell it when importing if it is a text field or a numeric field for ease of use and allow us to make that determination to eliminate the extra steps. We rely on leading zeroes in almost all of our data sets and I can't believe we are the only ones with this issue.