This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Last revision Both sides next revision | ||
|
contact-file-preparation-dates [2019/03/11 14:44] benc [Importing Dates into Sentori] |
contact-file-preparation-dates [2019/03/11 14:45] benc [Microsoft Excel] |
||
|---|---|---|---|
| Line 22: | Line 22: | ||
| 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: | ||