Data values instructions
General rules for the allowable data values for each column in the Partner Information worksheet and Special Allocations worksheet.
- Do not change format properties for any cell for any reason.
- A data field is optional unless noted otherwise.
- All column values for which a single code can be selected from a list of codes must be blank if the column designation and/or list of codes do not apply to the subject partner.
- Enter all dates in the format MM/DD/YYYY unless noted otherwise.
- Dollar amounts can be either whole dollars or dollars and cents unless stipulated otherwise. The smallest allowable dollar values is -99,999,999,999.99; the largest is +99,999,999,999.99 unless noted otherwise. If the smallest or largest allowable dollar amount for any column is different, the column instructions will give the specifications.
- Decimal fractions can have a maximum of eight (8) digits to the right of the decimal point (0.12345678) unless noted otherwise. The smallest allowable decimal fraction value is -1.0; the largest is +1.0. If the smallest allowable decimal fraction value for any column is not zero, the column instructions will specify the smallest allowable decimal fraction value for the column.
- The special designation NONE is equivalent to zero for both dollar amounts and decimal fraction values unless noted otherwise.
Related Content
-
Data column federal requirements
Format:
Article,
10 min read
-
Data columns state information
Format:
Article,
24 min read
-
Data columns city partner information
Format:
Article,
2 min read
-
States that require partner names reformatted
Format:
Article,
2 min read
-
Form 8805 data columns
Format:
Article,
1 min read
-
Special allocations data columns
Format:
Article,
3 min read
