topic Remove comma from table list in Documentation

Remove comma from table list

lcdega — Mon, 12 Jun 2023 09:41:55 GMT

Hi all,

Is it possible to remove the comma or set the table so that I get a full number in the highlighted column?
I have tried already to change my region settings as I could see in another similar topics, but this did not bring any change.
I am asking this, because I need to export this table in excel, but with this format excel is not able to read the values as number, only as text, preventing me to use a formula.

Thanks

Re: Remove comma from table list

Jan Millan — Mon, 12 Jun 2023 14:43:47 GMT

Is this number part of an expression where the number is formatted as a string using the STR() or STRCALCUNIT() functions?
If the answer to this question is yes, you may have to do another step to convert the string back to a number before taking it out to Excel.

Typically, when formatting numbers as strings in Archicad, the commas are retained in Excel. However, when dealing with numbers directly, they are displayed without commas. Please refer to the attached screenshot, which illustrates a quick schedule displaying the area both as a number and as a string in Excel which shows how the number does not retain the comma but the string does.

Re: Remove comma from table list

lcdega — Tue, 13 Jun 2023 10:19:22 GMT

Thanks, would it be possible to do this step directly in Archicad, without passing through Excel?