LinkBack URL
About LinkBacks
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?
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?
Normally, if you only want to show with a separator, use thenumber format: "#,##0"
Would show up as 123,456
Kind regards,
berlan
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,,
Last edited by rahi_feri; 04-11-2015 at 07:01 AM.
Understood. Thank you very much.
Last edited by zanshin777; 04-11-2015 at 11:29 AM.
Value : 154,87
Number Format :
Display : 154 and 87/100 dollars
How should be Number Format?
Value : 154,87
Number Format :
Display : 154 and 87/100 dollars
How should be Number Format?
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.
Originally Posted by shg
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?
Use these formats
#,### "and" .00"/100 dollars"
and
h "Hours"
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
1) It still won't work.
2) No. I mean why "8"?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks