#1   Report Post  
npn3055
 
Posts: n/a
Default 萬分位

亞洲各國的貨幣都有萬的單位, 為何Excel沒有提供萬分位, 而是只有*美的千分位??
我希望能達到如下的表示方式, 該如何做呢?

1,2345,6789
or
1'2345'6789
  #2   Report Post  
kk
 
Posts: n/a
Default


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


  #3   Report Post  
Max
 
Posts: n/a
Default

"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
--


  #4   Report Post  
npn3055
 
Posts: n/a
Default

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
--



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"