Function note

DOLLAR keeps the minus sign on an amount that rounds to zero; FIXED and TEXT drop it

FUNC.DOLLAR · FUNC.FIXED · FUNC.TEXT

FN-DOLLAR-001: DOLLAR keeps the minus sign on an amount that rounds to zero; FIXED and TEXT drop it

Quirk · measured · recorded 2026-11-04

-0.005 rounded to no decimals is zero. DOLLAR(-0.005,0) shows that as -R0 in en-ZA settings, keeping the sign of the input, while FIXED(-0.005,0), TEXT(-0.005,0) and TEXT(-0.005,"0") show 0.

Call and input routeInputsExcelCorrect valueRecorded in
=DOLLAR(-0.005,0)
formula-literal		As typed-R0—Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA
=FIXED(-0.005,0)
formula-literal		As typed0—Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA
=TEXT(-0.005,0)
formula-literal		As typed0—Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA
=TEXT(-0.005,"0")
formula-literal		As typed0—Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA

Basis: Four recorded readings of the same value.

Evidence and capture sources

Machine-readable note records