Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
萬分位
亞洲各國的貨幣都有萬的單位, 為何Excel沒有提供萬分位, 而是只有*美的千分位??
我希望能達到如下的表示方式, 該如何做呢? 1,2345,6789 or 1'2345'6789 |
#2
|
|||
|
|||
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
|
|||
|
|||
"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
|
|||
|
|||
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 |
Display Modes | |
|
|