On the attached image one sees that the top left chart has a 'standard' number format for the axis wheras the bottom right has a 'scientific' format.
Initially both charts had the 'standard' number format for the labels. After filling the dataset for the chart with VBA code running in Microsoft Access (no changes to formatting, only the numbers to be displayed) the one chart is OK but the other has been changed to 'scientific' format which is unwanted.
Why is this happening?
More important - how can I set the axis tick lables formatting back to 'standard' via VBA code?