Dollar sign left justified - data right justified - large space

[BuzzRogers]

I have this problem with data in a wide cell. Dollar sign is left justified,
data is right justified with a large annoying space between

 

[zxiqlpixs]

You have the formatting set to Accounting. If you want to $ to be next to the
numbers, change the formatting to Currency.

 

[JE McGimpsey]

Change your number format from Accounting to Currency.

Alternatively, to keep the other Accounting format elements, use
Format/Cells/Number/Custom

_($#,##0.00_);_($(#,##0.00);_($"-"??_);_(@_)

 

[BuzzRogers]

Thanks - wasted 30 mins looking for the solution myself - you saved me lots
of time.