Forum Discussion

Dennis Castle's avatar
Dennis Castle
Copper Contributor
Apr 14, 2018

Cell formatting

I have an accounting worksheet formatted in $ (.00) and right justified.  My problem is that I have some rows of cells that display the numbers one space to the left of being fully right-justified.  I have formatted the entire worksheet to be fully right-justified, but some rows continue to display one space to the left of other rows.  Any suggestions?

excel

2 Replies

Sort By
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Apr 15, 2018

    Hi Dennis,

     

    Most probably such cells are formatted with right indent. You may play with increase/decrease indent icons to check if something changes, or with cell alignment format through Ctrl+1.

     

Resources