Subfield Question ?

[suzel404]

Hi all,

How can I transform the number 1100000 to 1 100,000 ?

left(Field,len(Field)-3)&','&right(Field,3))) give me 1100,000

Thank for your help.

[Clever_Anjos]

=replace(replace(num(1100000 ,'#,##0.00'),',',' '),'.',',')

[suzel404]

Hi Clever,

Thank for your response but your expression gives 1100000 000,00. I want to obtain 1 100,000.

[#4]

Try this expression

=left(field,1)&' '&mid(field,2,3)&','&right(field,3)

hope it will help

[anbu1984]

Round(1100000/1000000) & ' ' & Num(Mod(1100000,1000000),'#,##0')

[its_anandrjs · Accepted solution]

You can try this also

=Left(left(1100000,len(1100000)-3)&','&right(1100000,3),1)&'  '&Right(left(1100000,len(1100000)-3)&','&right(1100000,3),7)

[suzel404]

Thank you at all.In fact I have a list with following values

1000

2000

10000

20000

100000

200000

1100000
and I want a dynamic format like :

1,000

2,000

10,000

20,000

100,000

200,000

1 100,000

Thank you.

[anbu1984]

Load If(Round(Num/1000000)> 0, Round(Num/1000000) & ' ','') & Num(Mod(Num,1000000),'#,##0') Inline [

Num

1000

2000

10000

20000

100000

200000

1100000 ];

[Clever_Anjos]

What are your configurations?

SET ThousandSep='.';

SET DecimalSep=',';

[Clever_Anjos]

PFA