Paxata Community Members: Something special in a community experience is coming your way. Stay tuned to this space.
Visit the official Paxata Documentation portal for all of your doc needs.
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?