A tiny negative amount keeps the word for minus before zero baht

Quirk · measured · recorded 2026-11-04

A negative amount that rounds to zero satang still gets the word for minus, ลบ: BAHTTEXT(-0.001) is ลบศูนย์บาทถ้วน. -0 gives plain ศูนย์บาทถ้วน.

Call and input route	Inputs	Excel	Correct value	Recorded in
`BAHTTEXT(-0.001)` cell-value2	number: `-0.001` `0xbf50624dd2f1a9fc`	`ลบศูนย์บาทถ้วน`	—	Excel 16.0 build 20430, Windows 64-bit, AMD Ryzen 7 4800H
`BAHTTEXT(-0)` cell-value2	number: `-0` `0x8000000000000000`	`ศูนย์บาทถ้วน`	—	Excel 16.0 build 20430, Windows 64-bit, AMD Ryzen 7 4800H
`BAHTTEXT(-0.005)` cell-value2	number: `-0.005` `0xbf747ae147ae147b`	`ลบหนึ่งสตางค์`	—	Excel 16.0 build 20430, Windows 64-bit, AMD Ryzen 7 4800H

Basis: 8 recorded readings.

Evidence and capture sources

DnaCalc · apps/dna-onecalc/tests/acceptance.rs 36ff603e690aca6e53930870c02fd5fa92a9004a · recorded_bahttext_retains_the_sign_of_a_negative_amount recorded readings pinned
CalcFunc-Evidence · cache/oracle-20430/build-20430/BAHTTEXT.jsonl.gz 4d5320dfdc385354469b4d506153357bb932ab08 · line 1210, key BAHTTEXT|0xbf50624dd2f1a9fc
CalcFunc-Evidence · cache/oracle-20430/build-20430/BAHTTEXT.jsonl.gz 4d5320dfdc385354469b4d506153357bb932ab08 · line 1225, key BAHTTEXT|0x8000000000000000
CalcFunc-Evidence · cache/oracle-20430/build-20430/BAHTTEXT.jsonl.gz 4d5320dfdc385354469b4d506153357bb932ab08 · line 1212, key BAHTTEXT|0xbf747ae147ae147b