Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to remove blank space? | Charts and Charting in Excel | |||
add blank space in cell if first name is not blank | Excel Worksheet Functions | |||
BLANK SPACE TO A NUMBER | Excel Worksheet Functions | |||
I want a blank space on a worksheet when the question is blank? | Excel Discussion (Misc queries) | |||
Can I add blank space instead of 'FALSE' in VLookup? | Excel Worksheet Functions |