Re-written February 2019

cformat switch:  #

Indicates that the column contains numeric data, which affects the way the column is sorted, the type of Auto-Filtering that would be applied by default, and causes negative values to display automatically in red unless overridden by the NegFgBg option.

Note that the # cformat code does not prevent the display of non-numeric characters, nor does it automatically format them or even right-justify them. For these additional effects, see the cformat > code and the Mask option. For editable cells, the # cformat code only allows the input of numeric digits, so you may want to add the "." and "-" cformat codes to explicitly allow the entry of decimal points and minus signs—and/or use Mask.

Note also that the # switch has a lower priority that the A switch.