Excel 2019 New Functions Microsoft have introduced the following new built-in functions in Excel 2019. Note that these functions have been available in Microsoft's subscription service, Office 365, since 2016. Context to calculate percentage increase. Let's say you have your total sales for each month. The values look OK but you want to calculate the percentage increase (or decrease) between each month. Method to calculate the percentage Subtract the two months' sales. The first thing we have to do is calculate the difference between 2 months. 26 Excel Tips for Becoming a Spreadsheet Pro. Microsoft's program does just about everything one could ask for in a spreadsheet. Become the office Excel guru in no time with these hacks and tricks.
-->Returns or sets a Variant value that represents the format code for the object.
Syntax
expression.NumberFormat
expression A variable that represents a Range object.
Remarks
This property returns Null if all cells in the specified range don't have the same number format.
Microsoft Excel 2019 16 24 Percent Percentage
The format code is the same string as the Format Codes option in the Format Cells dialog box. The Format function uses different format code strings than do the NumberFormat and NumberFormatLocal properties.
For more information, see Number format codes (Microsoft Support).
Example
These examples set the number format for cell A17, row one, and column C (respectively) on Sheet1.
Support and feedback
Microsoft Excel 2019 Download
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.