BR ↔ US Number Format Converter

A report exported from a US system arrives full of 1,234.56 and a spreadsheet set to Brazilian Portuguese reads every cell as text, or swallows the comma and shows 123456 instead. This tool rewrites the numbers one by one, line by line: the decimal mark and the thousands mark swap roles while everything around them stays put. Paste the whole column, pick the target format and copy it back.

Detection works per number, not per file. When both separators show up in the same number, the last one is the decimal mark: in 1.234,56 the comma closes it, so the number is Brazilian; in 1,234.56 the dot closes it. The awkward case is a lone separator followed by exactly three digits, since 1,234 can be one thousand two hundred thirty-four or one point two three four. The tool then hunts the rest of the text for an unambiguous number and copies that convention.

The detail that catches people comes from accounting: a value in parentheses is negative, so (1.234,56) comes out as -1234.56 rather than leaving a stray bracket in the column. Table mode touches only fully numeric fields, leaving headers, product names and the delimiter untouched. Forcing two decimal places rounds half up on the digit strings instead of going through floating point, so 9.995 becomes 10.00 and not 9.99.