Please enable JavaScript to view this site.

A-Shell Reference

Define a numeric formatting mask.

Mask=mask

Supports the same numeric mask options as the BASIC USING clause (e.g. "$###,###", "##.##", "#ZZZZ"). The mask is applied immediately before loading data into each cell, and again just prior to and after editing a cell (if the cell is editable). Note that:

Notes

In most cases, you will want to also specify the column format code > to cause the formatted data to be right-justified in the cell.

Although each column can have a separate mask, the total (combined) amount of mask storage is limited to 1024 characters.

If you want zero values to show as blank cells, rather than formatted according to the mask, set the cformat for the column to string ("S") rather than to numeric ("#").

Examples

Mask=$###,###.##

Mask=#ZZZZZ

Mask=###.##

History

A-Shell 5.1.1107.4 of 12 Apr 08:  The new NegFgBg allows control over the color used to display numeric cells with negative values.