Tablora · Library
Interpret one parenthesized negative amount
Accounting tables show negatives in parentheses, as in (1,234.50). Convert that one convention to -1234.50 and hold any value with a second sign.
Parentheses as a minus sign
Financial statements, management reports and many accounting exports print a negative amount in parentheses rather than with a minus: (1,234.50) instead of -1,234.50. Copied into a spreadsheet, such a value often arrives as text, so it is skipped in sums or, worse, typed in again as a positive figure.
The numeric normalizer recognizes parentheses around the whole value as one negative sign marker and rewrites the amount with a leading minus. Spaces just inside the parentheses are ignored, and a currency label inside them, as in ($1,234.50), is removed as usual.
From (1,234.50) to -1234.50
With Decimal separator . and Grouping separator comma, the source value (1,234.50) becomes -1234.50. The grouping comma is removed, the fraction stays at two digits and the sign moves to the front.
Where the parentheses sit matters. A currency symbol outside them, as in $(1,234.50), does not convert; the value is held for review and keeps its original text. Move the symbol inside or remove it in your copy, then calculate again.
A decimal-comma amount works the same way once the separators match: (1.234,50) with Decimal separator , and Grouping separator . also becomes -1234.50.
Steps for an accounting column
- Confirm from the source that parentheses mean negative in this document; some reports use them for other purposes, such as notes.
- Paste the table, choose the Delimiter and pick the amount column in Number column.
- Set the Decimal separator and Grouping separator to match the digits, not the parentheses.
- Press Calculate and check that every value that was in parentheses now starts with a minus.
- Look at Values left for review for values with two sign markers.
- Watch for a closing parenthesis lost in copying, as in (1,234.50 without the end. That value is not read as negative; it is held for review.
Double signs and the CSV prefix
- A value with both parentheses and a minus, such as (-100), or with parentheses and DR, is rejected instead of being turned positive by two reversals.
- Download (CSV) prefixes cells that start with a minus with an apostrophe so a spreadsheet does not treat them as formulas. Converted negatives therefore appear as '-1234.50 in the file; remove the prefix or convert the column after import if you need numbers.
- In the Tablora app, the XLSX export reads parentheses as negative in columns it treats as numbers and writes a real negative number, but it does not reject a second sign marker. Check any such cell against the page before exporting.
Original synthetic example
- Source value
- (1,234.50)
- Decimal separator
- .
- Grouping separator
- ,
- Expected outcome
- Normalized amount: -1234.50