Separate numbers with quotes (number formatting)

[#1]

Hello,

I would like to display the numbers like this:

1000 ==> 1'000

11'000 ==> 11'000

1000000 ==> 1'000'000

I've tried with the num function but without success. Can anyone help me ? Thanks!

[Sokkorn]

Hi,

For me, first we need to formate number into 1,000,000.00 then replace <,> to <'>. Somthing like this =REPLACE(NUM('1000000','###,###.#0'),',',CHR(39))

Regards,

Sokkorn

[#3 · Accepted solution]

=num(1000000000, '#'&chr(39)&'###.00','.' , chr(39))

Result: 100'00'00'000.00