Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hai there,
I got the sum value in billions eg: 564,786,789,231.00.....
when i created a chart diagram and tried to get the "Test on data point" i see all these 12 digits. but i would like to have only first 3 digits 564 billions.
i try to change in the number format, but i get 5647e+012
could any one help me out.
thank you
Do not allow pop-up for this expression, but create another one with a formula like = NUM(Column(1)/1000000000, '#,##0'). This one then may show up only.
Peter