I tried using Accounting format and the cells on my PC show $4,500 (no spaces) and not $ 4,500. Very odd behaviour! I still can't see how the OP's photo shows the $ so far away from the amount figures without it being in a column of its own.


Ah well it seems the OP may be sorted now.