For example, these numbers are using the “General” number format.
I’ll change back to General.
Dates also use number formatting.
I can easily switch from a short format to a long format.
Custom number formats let you extend number formatting based on your own needs, using special codes.
Here you’ll find a long list of built-in custom formats organized into groups.
In the Custom group, you’ve got the option to enter any valid code.
For example, I can display these dates as month names only with “mmmm”.
By default, Excel charts will pick up number formats from the data being plotted.
For example, if I use this data to make a simple column chart.
Then apply the currency format, the chart pulls in that formatting.
Notice if I uncheck this box, nothing happens, because Excel has already applied the currency format.
Dates work the same way.
For example, if I apply a custom number format to display only month names…
This format appears horizontal axis, because “linked to source” is enabled.
it’s possible for you to also apply number formats to chart elements directly.
