10 Experience
0 Lessons Completed
0 Questions Solved


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")