Mystery extra space

[fishcad]

On a column of currency entries I had two cells with an extra space at the end of the dollar amount. With one of the cells I reentered the number in case I put a space there. I tried formating the cell alignment. Neither moved the number to the right side of the cell. I then copied the format from another cell in the column and that fixed it. I know I could easily do that again for the other misaligned cell but I am curious about what is different about this cell that leaves the extra space.Extra space in cell.jpg

[Greg M]

Hi there,

It always makes things a LOT easier when we have a sample workbook rather than a screenshot to work with. With a workbook we can experiment - with a screenshot we just have to guess

My guess is that the Horizontal Alignment property of the "problem cell" has a value specified for Right Indent, but it could just as easily be a custom specification for the Number property of that cell.

Regards,

Greg M

[fishcad]

A portion of the sheet is attached. (I think.)

[alansidman]

Cannot replicate your issue. When I open your file, all is aligned to the right. See below.

Excel 2016 (Windows) 32 bit

	A	B	C	D
1	Paid on	For
2	Total	For	2018	$1,290.00
3	Total	For	2019	$2,600.00
4	December 16, 2019	For	Rcvd. Frank for Jan 2020	($200.00)
5	December 17, 2019	For	January 2020	$400.00
6	January 25, 2020	For	February	$400.00
7	January 30, 2020	For	Rcvd. Frank for Feb 2020	($200.00)
8	February 26, 2020	For	March	$400.00
9	February 26, 2020	For	Rcvd. Frank for Mar 2020	($200.00)
10	March 24, 2020	For	April	$400.00
11	March 24, 2020	For	Rcd. Frank for Apr 2020	($200.00)
12	April 27, 2020	For	May	$400.00
13	April 27,2020	For	Rcd. Frank for May 2020	($200.00)
14	May 26, 2020	For	June	$400.00
15	June 20, 2020	For	Rcd. Bill for Jul & Aug	($400.00)
16	June 29, 2020	For	July	$400.00
17	July 28, 2020	For	August	$400.00

Sheet: Sheet1

[bebo021999]

It probably was imported from other program.
You can fix it by add 0 to them without format every cells.

Place cursor at any blank cell
Copy
Hightlight destination area
Paste special/Operation: Add
OK

[GeoffW283]

I can reproduce the problem.

D5 abd D6 (these cells are right up against the right margin) have a value of $400.00 and are formatted as currency with negative numbers formatted as black with a preceding negative sign like: -1234.00

D8 and D12 (these cells appear to be indented) both have values of $400.00 and both cells are formatted as currency with negative numbers to be formatted in red with brackets like: (1234.00)

Currency format tries to align the decimal point across all rows and so the D8, D12 format needs to leave space for the right bracket for negative numbers.

You can fix your problem by selecting col-D and using the same currency format variant for all cells.

[fishcad]

Thanks. What I've done is format the negative numbers after entering them and I don't know why that positive cell got formated that way. I will reformat the whole column.