Totals bar problems

[joce]

Hi,

I am using the totals button to calculate the avergaes of my many different columns. But my problem is, that each value that has been entered are like follows: 0.12%, 0.73%,1.23% etc etc

but the end value I am getting in the totals field for these colums are coming out in the wrong format, no decimal place and no percentage signs

Does anyone know how I can rectify this???

Thanks

Joce

 

[vbaInet]

Copy the Format from the original field and paste in the Format property of the Avg field.