ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   why does blank space appear at end of number? (https://www.excelbanter.com/excel-discussion-misc-queries/181280-why-does-blank-space-appear-end-number.html)

Mary

why does blank space appear at end of number?
 
Sometimes a blank space appears at the end of a number in a cell.
Right-justify does not fix this. I tried deleting and re-entering, but
nothing seems to work. The other cells below and above are fully
right-justified, so one cell stands out. I've had this happen on numerous
occassions and don't know how to fix it.

Thanks,

Mary

pdberger

why does blank space appear at end of number?
 
Mary --

It may be that you (or someone) clicked the indent or outdent button on that
cell. Have you tried copying the format from a cell above or below that
doesn't show the space?

"Mary" wrote:

Sometimes a blank space appears at the end of a number in a cell.
Right-justify does not fix this. I tried deleting and re-entering, but
nothing seems to work. The other cells below and above are fully
right-justified, so one cell stands out. I've had this happen on numerous
occassions and don't know how to fix it.

Thanks,

Mary


Tyro[_2_]

why does blank space appear at end of number?
 
Could be cell formatting. For example some cells are formatted in number
format, completely right justified and some in accounting format which
leaves a space at the right for a ")" in case of negative numbers. Make sure
your cell formatting is the same for all cells.

Tyro

"Mary" wrote in message
...
Sometimes a blank space appears at the end of a number in a cell.
Right-justify does not fix this. I tried deleting and re-entering, but
nothing seems to work. The other cells below and above are fully
right-justified, so one cell stands out. I've had this happen on numerous
occassions and don't know how to fix it.

Thanks,

Mary





All times are GMT +1. The time now is 09:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com