number format in vba

[dinotom]

I am trying to set my tick labels format in my chart routine using ticklabels.numberformat

I can't figure out how to convert a Number like $1,000,000 to $1,000m

 

[pgc01]

Hi Thomas

Do this test. Select the chart and execute:

Sub TickLabelsSetNumberFormat()
 
With ActiveChart.Axes(xlCategory).TickLabels
    .NumberFormat = "$#,##0,""m"""
End With
End Sub

 

[pgc01]

P. S.

I assumed you were formatting the tick labels in the X-axis. If it's in the Y-axis replace xlCategory with xlValue.

 

[dinotom]

thank you, works fine now