'# ##0' Integer format string issue

[Christian_Lauritzen]

Hi,

When formatting a number using num(), e.g. =num(sum(count),'# ##0'), it is not possible to type # ##0 as a format string. The number will show up as 1000 ##0.

Instead, I have to go to the numbers tab for a chart, select Integer for some expression and copy the integer format string, then paste it into the formula - and wow! - it works! It looks the same, but the number now comes out as 1 000. Obviously it is not space but a special character that looks like space.

My question is; is it possible to write the Integer-with-space-format-code with the keyboard instead of doing the copy-paste work-around?

/Christian

[Christian_Lauritzen]

I should mention, there is a very techy solution to make the formatting work, namely, instead of typing space, you press control and type 160. That generates the magic special character. That does the trick but it is silly and it should not be expected for a user to memorize a special ascii code to make formatting work... My question is rather if there is a "normal" solution.

/C

[rbecher · Accepted solution]

Hi Christian,

but you can set the thousand separator to space:

=num(sum(count), '# ##0', ',', ' ')

- Ralf

[Christian_Lauritzen]

So simple... Of course! Thanks