View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MB MB is offline
external usenet poster
 
Posts: 53
Default DataTable number format

Hi,

I have a chart that I populate from arrays thru VBA code. The DataTable for
the chart shows the values as they are entered in the array. Is there a way
to have the values in the DataTable shows in the format "0.00%"?? please help!

I tried to use the FormatPercent function, the NumberFormat function, Format
function..etc. with no success.
Any help will be greatly appreciated.
Thanks,
MB