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

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

"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