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

 

[awoohaw]

Maybe try this custom format:
#,###.############
That will give all 12 after the dot. but not 13th.

 

[dk2]

Maybe try this custom format:
#,###.############
That will give all 12 after the dot. but not 13th.

with that code, 0.xxx and integer number will have error

[=0]0;[<1]0.###############;#,###.###############
I upgrade the code, but integer number will have . in the end.

 

[awoohaw]

mmm. Can you post a column of your numeric values in the 3rd column as text so have a practical example to work with?

 

[awoohaw]

try this:
##,##0.0############
or this
##,##0.#############

 

[dk2]

try this:
##,##0.0############
or this
##,##0.#############

It doesnt work well as my wish
My addon doesnt work well.
you can try with this random list:
0
0.0000004
1459.1235
I want this to be:
0
0.0000004
1,459.1235
thank you so much

 

[awoohaw]

When I format with this rule:

My result is this:

What is your system decimal marker? a dot or comma?

 

[dk2]

My

When I format with this rule:
View attachment 84925
My result is this:

View attachment 84926

What is your system decimal marker? a dot or comma?

My system decimal is dot, and thousand separator is comma
With this one, how to code.

 

[dk2]

When I format with this rule:
View attachment 84925
My result is this:

View attachment 84926

What is your system decimal marker? a dot or comma?

Just ignore the #8
My system decimal marker is dot, thousand seperator is comma.

 

[awoohaw]

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.############)?