Format number with thousands separator and all decimal

[dk2]

I have serial number like this, and I want to show thousands separator and all decimal for all number (keep all number after dot) by format cell option.
Can you help me with this one.
Thank you so much

 

[dk2]

Before you try any new formats, make sure you clear all formatting, including conditional formating. (On the HOME Menu from Ribbon, Go to the "Editing" sections, Select the "Clear" option, Clear ALL Formats.)

did you try that format? (#,##0.############)?

I clear all the format and try this one, has an error on 0 -> 0. and integer ex 15391 -> 15,391.

 

[awoohaw]

This should work, #,###.#########;-#,###.########;0

Mr Excel Questions 3.xlsm
	A	B	C	D	E
1	-4,197.602802115	4,593.682632329	10,791.576085101	-13,023.11304378	-373.97142486
2	18,719.77274019	3,309.582552716	8,886.761961477	15,695.496498541	-18,958.611961262
3	-18,441.096922484	-2,419.694129015	-11,870.964244917	0	2,366.879959349
4	19,502.07196653	-4,836.1069123	2,756.252804146	3,311.444226428	1,870.440861531
5	17,170.599440557	-3,806.304619218	15,340.476082561	-10,805.816193853	15,247.335800672
Sheet3

 

[awoohaw]

This should work, #,###.#########;-#,###.########;0

Mr Excel Questions 3.xlsm
	A	B	C	D	E
1	-4,197.602802115	4,593.682632329	10,791.576085101	-13,023.11304378	-373.97142486
2	18,719.77274019	3,309.582552716	8,886.761961477	15,695.496498541	-18,958.611961262
3	-18,441.096922484	-2,419.694129015	-11,870.964244917	0	2,366.879959349
4	19,502.07196653	-4,836.1069123	2,756.252804146	3,311.444226428	1,870.440861531
5	17,170.599440557	-3,806.304619218	15,340.476082561	-10,805.816193853	15,247.335800672
Sheet3

It looks like it is still putting a decimal point on whole numbers. ugh

 

[dk2]

It looks like it is still putting a decimal point on whole numbers. ugh

#,###.#########;-#,###.########;0
it does not work well
thank you so much for your support

 

[awoohaw]

yea. I looked online in this and other forums as well as the microsoft web site, but I could not find anything about it.
I think it is strnage that it works the way you want for general, but you have don't get the thousands separator. I wish I could help more.

 

[dk2]

yea. I looked online in this and other forums as well as the microsoft web site, but I could not find anything about it.
I think it is strnage that it works the way you want for general, but you have don't get the thousands separator. I wish I could help more.

It’s ok. I will use without thousand seperator. Thank you so much