Friday, September 26, 2014

How To Align Number To Be At The Center Of Active Cell(S) In Excel's Workbook.

Cell is with the decimal number inside it. The number usually keeps at the right of the border. Anyway, if you want to format those figures to be in the middle of cell's border. It is not too difficult at all to do that.

Hereafter is the step-by-step format cell to center the figures being in the middle:
  •  Select the cells to be centered. (Cell "B5" ex. image below).
  • Click on the Format Cells > Number > Custom > To type #,##0.00 into the code box. (Type the among of digit as same as the data entered)
Before

Process 

After
If it doesn't work. Align the format cell by clicking the center like below image.
See more other tips:
Would you like to surf my other blogs?

No comments:

Post a Comment