I just imported an Excel spreadsheet into a SharePoint list, and all of my data was imported as single or multiple lines of text. While appropriate for some instances, in other cases, like a name field, I'd prefer to have a data type of Person or Group
instead of free-form text strings.
I'm assuming that using Excel's field definintions to define numeric vs. date will carry over OK, but how can I force a particular data type that's not on Excel's list of standard data types? Alternatelty, is there any place in SP that I can edit field types?
Thanks