I want to change just whats displayed.

I think numbers are rounded up so - if number is 162.50 or above it is showing 163 and if the number is 162.49 or below - it showing 162.

however my numbers are in millions; and for the purposes of chart and legend in the chart - I want to convert the number (at least for display purposes) from $1,623,536 to $1,623 in the chart and the legends of the chart.

I have tried using custom number format - with $#, it then changes the number from $1,623,536 to $1623. I do not know why it is not showing the comma after 1 to make the number appear like $1,623.

Please advice.

Regards

Umesh Banga