DataTable number format

M

MB

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format numbers in chart datatable 3
Binding a DataSet to a ListObject 5
OWC11 DataSource binding 0
Replace legend with Range of Cells 0
Problem Copying DataTable into Worksheet 1
.find does not find if .NumberFormat = "#,##0.00" 2
Excel and Asp.NET 1
loop help 6

Top