Thousands separator

Hi Karl,

thanks for your question, and sorry for the trouble.

The trick here is to only add the thousand separator later, via the NUMBER_FORMAT_EU() function, i.e. after your calculations have been done.
This means that you will need the numbers as pure numbers for any formulas and calculations, and can then e.g. hide that column. In addition, you add another column that uses the mentioned function to show the formatted numbers.

Regards,
Tobias

Hello Tobias,
thank you for your hint, this helped me to solve my problem.
But one little problem, the separator is a space, is it possible to use a dot as separator? And how to ignore empty cells to show not the 0?

Regards,
Karl

• This reply was modified 6 years, 9 months ago by meierseppl.

Hi Karl,

I’m not sure where that space is coming from. The TablePress formatting functions NUMBER_FORMAT() and NUMBER_FORMAT_EU() (see https://tablepress.org/tablepress-features-formulas/) only use , and ..

Regards,
Tobias

Hello Tobias,
thank you for your reply, i will search it and hope to find it.

Regards,
Karl

Hi,

no problem, you are very welcome! ?? I hope this helps!

Best wishes,
Tobias

I’ve added NUMBER_FORMAT in a hidden column and hidden row in order to get a thousands separator for sums. But now when I export the table to add more columns and rows, the number_format function turns into #NAME? and can’t be re-imported.

Example
In a cell in TablePress I have typed =NUMBER_FORMAT(O37)
Upon export into CSV it appears as #NAME? But upon hover =NUMBER_FORMAT(037) appears in the formula bar.
Upon import back into TablePress it now shows up as #NAME? and every instance of NUMBER_FORMAT is gone

What am I doing wrong?
Thank you

Nevermind… Forgot the {}
But if there is a way to combine NUMBER_FORMAT with the SUM formula in the same cell, that would be super cool (and less confusing for my editors).
Thanks.

Hi,

I’m not sure what you mean with “combine” the formulas, but something like

=NUMBER_FORMAT( SUM( ... ) )

will work fine.

Regards,
Tobias

If there is a cell that you want displayed with the thousands separator that is not a sum cell, BUT that cell is included as part of a formula, what is the best method?

Example
https://insideevs.com/december-2017-plugin-electric-vehicle-sales-report-card/
I want the thousands separator to display in each cell. (I use NUMBER_FORMAT for the total columns).

Would I essentially have to create two columns for every month and then hide one with just the number and show the other with the NUMBER_FORMAT function?
Is there an easier, less clunky way?

Thank you.

Hi,

yes, that extra hidden column for each month is the only real solution that I can think of here. Sorry :-/

Regards,
Tobias

Thanks again for the reply. We will workaround it.

Hi,

no problem! Sorry that I could not offer a better solution here.

Best wishes,
Tobias