Dollar sign left justified - data right justified - large space
 

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

Answer: Dollar sign left justified - data right justified - large space
 

It sounds like you may have accidentally added extra spaces between the dollar sign and the data in your cell. Here's how you can fix it:

1. Double-click on the cell to enter edit mode.
2. Place your cursor just to the right of the dollar sign.
3. Press the backspace key to remove any extra spaces.
4. Press the delete key to remove any extra spaces to the left of the data.
5. Press the enter key to exit edit mode and see if the spacing issue has been resolved.

If the spacing issue persists, you may need to adjust the cell formatting. Here's how:

1. Right-click on the cell and select "Format Cells" from the dropdown menu.
2. In the Format Cells dialog box, select the "Alignment" tab.
3. Under "Horizontal," select "Right" to right justify the data.
4. Under "Vertical," select "Center" to center the data within the cell.
5. Under "Indent," set the "Left" and "Right" values to 0 to remove any extra spacing.
6. Click "OK" to apply the formatting changes.

These steps should help you resolve the issue with the dollar sign being left justified and the data being right justified with a large space in between. Let me know if you have any other questions!

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

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

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