format in MS Access chart data table

Y

Yolanda

iI created a chart from access table. The format of data is stored in
percentage with 2 dec. format. When I creat the chart with data table
displayed, the 9.8% diplay as .098 in the data table. Even I changed the
number in data sheet to %, it appears as 9.8% in design view, but when I
switch to the data view, ir changed back to .0980. I managed to change the
axis and data label to % format, but it will not work with the data table.

I have another chart with currency in 6 dec. format, the data in the data
table shows in scientific format.

Is anyone willing to help me to fix this problem?
 
Top