ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
https://www.reddit.com/r/googlesheets/comments/1iujgkk/custom_number_format_for_commas_and_no_trailing/
3
4
Numerical input is dynamically changed to a number format #,##0 for an integer, otherwise #,##0.0######
5
6
See script in Extensions / Apps Script
7
8
9
10
123
11
123,456.8
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100