Format string: 0 as 0 ... 1000 as 1,000

Hi,

I was wondering what the correct format string for thousand separator is
0,0 or #,### don't work because they are fine for any number except for 0 where they either display 00 or nothing.

Thanks,

Tom


Answer this question

Format string: 0 as 0 ... 1000 as 1,000

  • wfillis

    Hi,

    Do you mean to display 0 as 0 and 1000 as 1,000 if so, try this format string: #,##0





    cheers,

    Paul June A. Domag


  • tixall

    Thanks, that did it!

  • Format string: 0 as 0 ... 1000 as 1,000