y-axis label number formatting

mh10

on y-axis i have number like,
0
1000
100000
200000
300000

I am looking to show them in format
0
100,0
100,000
200,000
300,000

I used format specifier editor of y-axis....and mentioned 000,000 in Pattern option under Advanced

but it is showing on y-axis as
000,000
001,000
100,000
200,000
300,000

how can i show these number as
0
1,000
100,000
200,000
300,000


Any suggestions?

Thanks

bhanley

Looks like the column on your data set is defined as a string? Can yo update the data set to use the correct data type? I think that will help with the formatting.