This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
contact-file-preparation-dates [2019/03/11 14:44] benc [Importing Dates into Sentori] |
contact-file-preparation-dates [2019/03/11 14:47] (current) benc [Microsoft Excel] |
||
---|---|---|---|
Line 18: | Line 18: | ||
- | ===== Microsoft Excel ===== | + | ===== Microsoft Excel Spreadsheets ===== |
While your data may //appear// to be in the required **DD/MM/YYYY** format when you open an Excel spreadsheet file, it may not actually be //stored// in the correct way for Sentori to access it. | While your data may //appear// to be in the required **DD/MM/YYYY** format when you open an Excel spreadsheet file, it may not actually be //stored// in the correct way for Sentori to access it. | ||
- | To ensure it is, the simplest option is to use Excel's "Text to Columns" feature. | + | To ensure it is, the simplest option is to use Excel's **Text to Columns** feature. |
Here's how: | Here's how: |