Symptom:
After giving different data series (from non-Excel format), certain cells in the given columns take a date value. Set to number format is giving back not the original number in that cell.
Solution:
Windows regional settings must be changed to English (United States) format.
Control Panel => Clock & Area => Region => Format
