For any columns you would like to keep the data exactly as shown, such as keeping all leading and trailing 0s in account numbers, select " Text" as the " Column data format". The default is " General", which will allow Excel to guess the format and convert it to the corresponding type. This step lets you specify the data type for each column, as well as indicate if a column should not be imported (" Do not import column (Skip)").Select " Next" to proceed to step 3 of 3.For a preview of how your data will be separated refer to the " Data preview" section in the bottom portion of the Import Wizard. For files delimited by a character not listed, type the character in the " Other:" option.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |