I am trying to format numbers in Excel, and my desired outcome is similar to the Accounting format, where the $ is on the left and the value is on the right. I’m trying to include multiple numbers, so I need to use the TEXT function to convert each of them, and concatenate.

As a first step I tried to duplicate the behaviour of the Accounting format for positive numbers with the format string _‑$* #,##0.00_-, but it never has any space between the $ and the number.

Am I doing something wrong with the format string, or is there some Excel setting I’m missing that’s preventing the TEXT function from filling the cell with spaces here?