The following are special unit rules:
- An integer or float may contain only a single appearance of one of these unit characters.
- The unit character may appear either before or after the string of digits.
- There may be any number of blank spaces between the string of digits and the special unit character.
Excel cells with one of the four recognized units can be pasted into scorecard or table cells whose category unit matches. The following scenarios are supported:
- No Excel unit into scorecard or table cell whose category has any unit - White (accept the number - no message)
- Known Excel unit, into scorecard or table cell whose category has same unit - White (accept the number without the unit - no message)
- Known Excel unit (only) into scorecard or table cell whose category has no unit (integer/float) - Yellow (accept the number without the unit - Message: "The value was pasted without the <($)/(o)/(€)/(%)> unit.")
- Known Excel unit into scorecard or table cell whose category has a different unit - Red (message): "You may not paste <($)/(o)/(€)/(%)> cells into (<category_unit>) cells."
- Unknown unit (which is the same as a mixed text-numeric) into float/integer field w/wo unit - Red (message): "Pasted data is not a valid numeric value." (This message will be used any time text is pasted into a float/integer field).