danhendo888
Board Regular
- Joined
- Jul 15, 2019
- Messages
- 167
- Office Version
- 365
- Platform
- Windows
Suppose I have two numbers
8170.5999
618.111
Is there a formula that shows them as:
8,170
618
That is, show a comma when over 999
I used TEXT with "$0,000" but this shows the comma even for numbers below 1,000
8170.5999
618.111
Is there a formula that shows them as:
8,170
618
That is, show a comma when over 999
I used TEXT with "$0,000" but this shows the comma even for numbers below 1,000