Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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: