The Drupal Node Import module is wonderful for importing content from any source. There are a couple of pitfalls to watch out for.
Date formatting
Dates have to be in the following styles:
- "YYYY-MM-DD"
- "MM/DD/YYYY"
- "DD.MM.YYYY"
The formatting is extremely important. For example, DD/MM/YYYY won't work, because it doesn't have dots.
Once it's in Drupal you can display it however you wish.
Number formatting
If importing numbers, they must not have commas. For example, "8000.00" is valid but "8,000" is not.
If using Excel, select your numbers, press CTRL/CMD + 1 and select number. Then, uncheck the "Number Separator" option.
If you don't do this, then the number will be ignored!