The Format property is used to to format the contents of Labels. The full path to this property is Area.Axis.Labels.Format. This property has multiple values.
Number. The N value of the Format property is used for the general display of numbers. When filling the Format, after the N value, it is possible to specify the number of decimal places that you want to use. If no numbers are specified after N then decimal places will be shown only if they are present as a result of calculation. The picture below shows a chart with the Format property of Series Labels set to N:
Currency. The C value of the Format property is used to display Labels with a currency symbol. With the C value, it is possible to specify the number of decimal places that you want to use. The picture below shows a chart with the Format property of Series Labels set to C:
Percentage. The P value of the Format property is used to display Labels with percent symbol. After the P value, it is possible to specify the number of decimal places that you want to use. The picture below shows a chart with the Format property of Series Labels set to P:
Date formatting. The MM/dd/yyyy, MMMM dd, yyyy MMMM values of the Format property convert values of arguments to date. MM/dd/yyyy - the date is shown like "01.20.2010", MMMM dd - the date is shown like "September 29", yyyy MMMM - the date is shown like "2010 March". The picture below shows a chart and its Format property is set to MM/dd/yyyy:
To reset the Format property of selected cells, and return to the default format, clear the Format by selecting empty field.