Column types and number formatting

By default MMTable treats every column as text. Set a column type to enable correct sorting (numerical, chronological) and consistent display.

Set a column type

1. In the editor, click the column header cell.
2. The column toolbar shows on the right. Pick a Type: text, number, currency, date, or percent.
3. Save.

What each type does

Text — default. Sorts alphabetically, displays as-is.

Number — sorts numerically. 9 comes before 10. Apply number formatting below to control display.

Currency — same as number, but the display includes the prefix and thousand separator by default. 1234.5 in the cell shows as $1,234.50 on the front end if you set the format that way.

Date — parses common date formats and sorts chronologically. Store dates as 2026-05-26 for unambiguous parsing; locale formats like 5/26/26 work too but disambiguate based on the user's browser locale.

Percent — same as number, suffixed with %.

Number formatting

Each numeric column (number, currency, percent) can have:

• Prefix — e.g. $ for USD, € for EUR. Defaults to empty.
• Suffix — e.g. kg, %, /mo. Defaults to empty for number/currency, % for percent.
• Decimal places — how many digits after the decimal point. Blank means "as stored".
• Thousand separator — toggle commas (or your locale's separator) on numbers ≥ 1000.

Store the raw number in the cell — 1234.5, not $1,234.50. The formatting layer renders it for display, but sort and CSV export use the underlying number.

Per-cell formulas

You can compute a cell's value from other cells in the same row. Prefix the cell text with = and reference columns by letter:

=A*B*0.1

Supported: + - * / ( ), decimal numbers, and column references (A, B, C… and legacy col1, col2 syntax). Anything else is rejected.

Formulas evaluate server-side at render time. Cells that reference other formula cells see the raw stored text of those cells, not the computed value — to chain calculations, store constants in the intermediate cells.