Number Format Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/number-format/ Bestselling Excel and Power BI Courses Fri, 10 Mar 2023 23:15:25 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Number Format Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/number-format/ 32 32 How to Create and Use Excel Custom Number Formatting https://www.xelplus.com/why-you-should-be-using-custom-number-formatting/ Fri, 24 May 2019 23:42:00 +0000 https://www.xelplus.com/?p=12335 Taking advantage of Excel's custom number formatting is a must for any advanced Excel user. Learn some easy and useful tricks when it comes to custom formatting.

The post How to Create and Use Excel Custom Number Formatting appeared first on Xelplus - Leila Gharani.

]]> Learning Excel Custom Number Formatting https://www.xelplus.com/excel-custom-number-formatting_1/ Sun, 17 Mar 2019 11:36:00 +0000 https://www.xelplus.com/?p=12788 Learn all about Excel's custom formatting - what is the rule for the custom formatting dialog box? How can you use it to hide zero values and much more.

The post Learning Excel Custom Number Formatting appeared first on Xelplus - Leila Gharani.

]]> Calculate Percentages the Right Way in Excel (% Change & Amount after % increase) https://www.xelplus.com/calculate-percentage-change/ Fri, 22 Feb 2019 19:43:00 +0000 https://www.xelplus.com/?p=12845 Learn how to calculate percentage change correctly. In addition, find out how to calculate end value when there is a percentage increase or decrease.

The post Calculate Percentages the Right Way in Excel (% Change & Amount after % increase) appeared first on Xelplus - Leila Gharani.

]]> Smart Uses of Custom Formatting in Excel https://www.xelplus.com/smart-uses-of-custom-formatting/ Wed, 30 Aug 2017 14:36:00 +0000 https://www.xelplus.com/?p=14129 Conditional formatting is great at bringing attention to specific values, whether high/low, deviations, variances. It makes interpreting the data easier. But it can also significantly slow down your workbook. There is a faster alternative. You can use Custom Number Formatting to bring attention to data. Learn how to use it, how to add color-coded up/down errors and percentage deviations.

The post Smart Uses of Custom Formatting in Excel appeared first on Xelplus - Leila Gharani.

]]> Smart Uses of Custom Formatting in Excel – Part 2 https://www.xelplus.com/smart-uses-of-custom-formatting-part-2/ Wed, 30 Aug 2017 14:36:00 +0000 https://www.xelplus.com/?p=14155 Conditional formatting is great at bringing attention to specific values, whether high/low, deviations, variances. It makes interpreting the data easier. But it can also significantly slow down your workbook. There is a faster alternative. You can use Custom Number Formatting to bring attention to data. In part 2, learn how to add any symbol to custom number format, how to use up/down arrows for percentage variances, and how custom formatting works with thresholds and icons.

The post Smart Uses of Custom Formatting in Excel – Part 2 appeared first on Xelplus - Leila Gharani.

]]>