Rating File Ranges

Written By Jessica Moore (Super Administrator)

Updated at August 13th, 2026

When building a rating file, Excel may interpret a numeric range containing a hyphen as a date. For example, entering 4-7 could cause the cell to display 04-Jul.

How to prevent this

Enter the range using decimal values:

  • Incorrect: 4-7
  • Correct: 4.0-7.0

Using decimals helps ensure the value remains a numeric range rather than being automatically reformatted as a date.

Before uploading your rating file, check that all ranges display correctly and have not been converted into dates.