�分�
 

亞洲å�„國的貨幣都有è�¬çš„å–®ä½�, 為何Excel沒有æ��ä¾›è�¬åˆ†ä½�, 而是å�ªæœ‰æ*�美的å�ƒåˆ†ä½�??
我希望能�到如下的表示方�, 該如何�呢?

1,2345,6789
or
1'2345'6789

Use Custom Format

Format | Format Cells | Number | Custom

[=100000000]#'####'###0;[=10000]#'###0;General

or

[=100000000]#,####,###0;[=10000]#,###0;General


"npn3055" wrote in message
...
?????????????, ??Excel???????, ????????????
?????????????, ??????

1,2345,6789
or
1'2345'6789

"npn3055" wrote:
?????????????, ??Excel???????, ????????????
?????????????, ??????

And for completeness' sake to kk's response <g, here's a
Babelfish translation of the OP's post above (Chinese to English):

The Asian various countries currency all has ten thousand units, hasn't
Excel provided why ten thousand ranks, but is only has European and American
thousand ranks? ? I hoped can achieve the following expression way, how
should do?

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

Thanks to KK and Max.

Actually I know the solution. But I ask this question for reminder. This
rank should be build into Excel.
It should not convert by customize funcion. M$ should pay more attention in
asia market.



"Max" 來函：

"npn3055" wrote:
?????????????, ??Excel???????, ????????????
?????????????, ??????

And for completeness' sake to kk's response <g, here's a
Babelfish translation of the OP's post above (Chinese to English):

The Asian various countries currency all has ten thousand units, hasn't
Excel provided why ten thousand ranks, but is only has European and American
thousand ranks? ? I hoped can achieve the following expression way, how
should do?

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--