Excel - Formatting, How to
The below listed is not the complete topics, but if you cannot find answers to half of them, you sure are the candidates of the workshop.
- Combining Text and a Formatted Date;
- Coloring Numbers Based on Specific Criteria;
- Display Rounding Numbers to Thousands or Millions;
- Displaying Figures in Financial Reports Rounded to Thousands with style box;
- Formatting postive,Negative Number with Parentheses aligned by decimal point;
- Replacing Zeros with Dashes or blank in Number Formatting;
- Coloring Even Numbered Rows in a List;
- Auto format SubTotals (合計) and Grand Total (總計);
Workshop
|