Change numbers to display as thousands or milions

[akhaliq7]

I created a table using the enter data option. In that table I added some sales figures. I would like to display those figures as thousands or millions. For example 2.5M how can I achieve this?

[SergioSilvaPT · Accepted solution]

Hi @akhaliq7 ,

You have an option in the Format Visual were you can choose the Display units type:

You can choose Thousands

Or Millions

It formats automatically for you.

Regards,

Sérgio Silva 

If this post helps, then please consider Accept it as the solution to help the others find it more quickly.