Can anybody help? I've created a chart in a Microsoft Access report
and have selected display datasheet so that the chart data is
displayed in a table below the chart.

However, I cannot seem to get the datasheet formatting right. For
example, financial amounts are appearing as 1234.8 where I would like
them to appear as £1,234.80. I have tried formatting the datasheet and
chart as well as the base queries behind the report, but cannot get
the values in the datasheet to format.

Any ideas?

Thanks in advance.