Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
=num(1000000000, '#'&chr(39)&'###.00','.' , chr(39))
Result: 100'00'00'000.00
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
=num(1000000000, '#'&chr(39)&'###.00','.' , chr(39))
Result: 100'00'00'000.00