Logical help

[Anonymous]

Hi all,

Can any one help me in understanding this logic:

"LET vZahlenformat_EN = chr(39) & '#,##0.' & chr(39) & '& Repeat(' & chr(39) & '#' & chr(39) & ', $(vDezimalstellen))' "

[alexandros17]

LET vZahlenformat_EN = chr(39) & '#,##0.' & chr(39) & '& Repeat(' & chr(39) & '#' & chr(39) & ', $(vDezimalstellen))' "

Is formatting decimal part of a number setting the number of decimal digits:

chr(39) is the value for the character '

the instruction Repeat, repeats a symbol more times.

so if you replace chr(39) with ' and remove the existings characters ' the string becomes:

'#,##0.' & Repeat('#',$(vDezimalstellen))

that is a concatenate (& symbol) between #,##0. and # repeated vDezimalstellen times