View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Dollar sign left justified - data right justified - large space

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);_($"-"??_);_(@_)

In article ,
BuzzRogers wrote:

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