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

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

"zxiqlpixs" wrote:

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