3/06/2019

Excel cell: date number error

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

No comments:

Post a Comment