badtime7
Joined
10 Experience
0 Lessons Completed
0 Questions Solved
Activity
Posted in Thousand separator and Number formating
Enclose the thousands separator in double quotes in your custom number format: #","##0","000
I'm unfortunately not aware of a way to include these in a TEXT() function, but it works fine when just using the cell's format.
Edit: Actually, adding an extra double quote to each of them worked. Example:
=TEXT(A1; "#"",""##0"",""000")