Custom Number Format to Determine hundred, thousand, million and billion

[muhammad susanto]

hi all...

i'm looking for in Custom Number Format to determine
number with separator hundred, thousand, million and billion in Indonesia Format..
mark dot (.) is not decimal but separator

Excel 2007
	F	G
5	data	custom number
6	100	100
7	1000	1.000
8	10000	10.000
9	100000	100.000
10	1000000	1.000.000
11	10000000	10.000.000
12	100000000	100.000.000
13	1000000000	1.000.000.000
14	10000000000	10.000.000.000
Sheet1

any help, thank in advance..

m.susanto

 

[RoryA]

I think that would just be:

#.##0

unless I have missed something.

 

[muhammad susanto]

hi Rory, sorry it not works...

 

[RoryA]

Please elaborate. You may need to use a comma in place of the decimal point in the format code.

 

[muhammad susanto]

here is this a long code

_-* #.#[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0_]#0_[/URL] -;-* #.#[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0_]#0_[/URL] -;_-* "-"_-;_-@_-

may be more simpler/shorter?

 

[RoryA]

What actually happens with that code?