Converting Values into millions

[akuku]

Hi!

I've found custom format which enables me to convert values into millions like below:

_-* #.##0000_-;-* #.##0,00_-;_-* "-"??_-;_-@_-""

The only problem is that let's say instead of 111,111,222 I get 111.111222 and I would like to have only 2 decimal points like that 111.11

Thanks for help!

 

[SirJB7]

Hi, akuku!
Try changing the format to:
_-* #.##0,00_-;-* #.##0,00_-;_-* "-"??_-;_-@_-""
Regards!

 

[NARAYANK991]

Hi ,

You might find the following link useful :

http://www.techrepublic.com/blog/mi...in-excel-to-display-easier-to-read-millions/#.

From the format that you have posted , it appears that your decimal character and your thousands separator may be different from what they are in the English version.

Narayan

 

[akuku]

Hi again,

now I received some totally different format by using _-* #.##0,00_-;-* #.##0,00_-;_-* "-"??_-;_-@_-""
as SirJB7 posted.

That's weird

 

[Debraj]

Try this..

#.00,," M";-#.00,," M";"-"

 

[SirJB7]

@akuku
Hi!
My answer pointed towards the decimal places, but reading again your question about the millions I join @Debraj(ex-Roy)'s suggestion.
Regards!