https://bugs.documentfoundation.org/show_bug.cgi?id=150923
--- Comment #4 from Robert Gralak <[email protected]> --- (In reply to Mike Kaganski from comment #2) > This is not a bug. > > First of all: what is your expectation using the "TEXT(DEC2HEX)"? The > TEXT(..., "#") function formats the passed number according to the numeric > format string; while DEC2HEX creates a *string* representing the number in > hexadecimal form. > (...) > > Closing NOTABUG. Use DEC2HEX by its own, without TEXT. Thank you for this detailed explanation. Looks like it was quite late since I didn't notice it myself. Now I can't remember why I used such a combination, for sure at some point there was a problem with getting the text format for the output and the TEXT function remained even when it was no longer needed. Thank you Mike (and others) again and sorry for the confusion :) -- You are receiving this mail because: You are the assignee for the bug.
