Custom Number Formatting

[zanshin777]

There are examples for custom number formatting on the book which I don't understand some of them.

Here we go;

1)

Value : 123456
Number Format : #,###,
Display : 123

I think "Display" should be "1,234,". Shouldn't it?

[berlan]

Normally, if you only want to show with a separator, use thenumber format: "#,##0"
Would show up as 123,456

Kind regards,
berlan

[rahi_feri]

hi
this format #,###, is correct but it shows numbers in thousands because of #,###,
you should use this format #,###
when you add two commas like this #,###,, numbers shown as millions
Example :
To display 12000 As 12,000 Use this code #,###
To display 12000 As 12 (Thousands) Use this code #,###, Or #,
To display 12200000 As 12.2(Millions) Use this code #,###.0,, Or 0.0,,

[zanshin777]

Understood. Thank you very much.

[zanshin777]

Value : 154,87
Number Format :
Display : 154 and 87/100 dollars

How should be Number Format?

[zanshin777]

Value : 154,87
Number Format :
Display : 154 and 87/100 dollars

How should be Number Format?

[MrShorty]

I think one of the most useful help files I ever used was the number format code description page (This one is for Excel 2011, there should be a similar page in your 2010 installation, though number format codes don't seem to change much if at all from version to version: https://support.office.com/en-us/art...3-80F18B4EAE68 ). A number format code like "0 0/100" should be close to what you want.

[zanshin777]

1)

Value : 154,87
Number Format :
Display : 154 and 87/100 dollars

0 0/100 or 0 "and" 0/100 "dollars" don't work. How should be the custom format?

2)

Value :0,345
Number Format :h "Hours"
Display : 8 Hours

Why did it become "8"? Where does it come from?

[AlKey]

Use these formats

#,### "and" .00"/100 dollars"

and

h "Hours"

[zanshin777]

1) It still won't work.

2) No. I mean why "8"?