(Created page with "==Guide==") |
(→Guide) |
||
Line 1: | Line 1: | ||
== | ==Things to Consider== | ||
* Date Format should be in '''dd/mm/yyyy''' (entry time in Excel as dd/mm/yyyy) - Updated 14 Nov 2013 | |||
[[File:Excel-DateFormat.jpg|500px|center]] | |||
* Float, Currency & Integer type Must not had ''',''' (comma) or Currency '''Symbol''' & '''Default Value''' is 0 not empty | |||
* Below is the column type can/can't import | |||
[[File:Excel-Import-02.jpg|700px|center]] | |||
* Try just use Alphanumeric for the '''Worksheet Name''' | |||
[[File:Excel-Import-06.jpg|700px|center]] |
Latest revision as of 01:24, 1 March 2017
Things to Consider
- Date Format should be in dd/mm/yyyy (entry time in Excel as dd/mm/yyyy) - Updated 14 Nov 2013
- Float, Currency & Integer type Must not had , (comma) or Currency Symbol & Default Value is 0 not empty
- Below is the column type can/can't import
- Try just use Alphanumeric for the Worksheet Name