W3C home > Mailing lists > Public > www-international@w3.org > October to December 2010

Re: [css3-text] text-transform: han-numerals

From: Takayuki Akimoto <taka-akimoto@thoton.co.jp>
Date: Sun, 31 Oct 2010 16:01:20 +0900
Message-ID: <AANLkTikwXT6p0jr65zMbPepOXZJyXNSbuQWhE8yPi+zU@mail.gmail.com>
To: brad.kemper@gmail.com
Cc: www-style@w3.org, kojiishi@gluesoft.co.jp, eb2m-mrt@asahi-net.or.jp, alan@css-class.com, www-international@w3.org, fantasai.lists@inkedblade.net, Charles.Belov@sfmta.com
Microsoft Excel 2007 Japanese Edition supports NUMBERSTRING() function.

This built-in VBA function converts numerals to han ideographs.

Although NUMERSTRING() is undocumented and little known even to
Japanese users, the function really works.


ideographs = NUMBERSTRING(value, format)


NUMBERSTRING(12345, 1) = “一万二千三百四十五”
NUMBERSTRING(12345, 2) = “壱萬弐阡参百四拾五”
NUMBERSTRING(12345, 3) = “一二三四五”

So, if you have a chance to use this most popular spreadsheet
application, why not try out.

For reference, here's Japanese documentation found on the Net:


Hope my information will help.

Best wishes,
Thoton Akimoto

On Oct 29, 2010, at 3:16 PM, "Belov, Charles" <Charles.Belov@sfmta.com> wrote:

> Brad Kemper wrote on Friday, October 29, 2010 2:07 PM
>> How about a fourth option for general number formatting? For
>> instance (where "d" stands for "digit"):
>> Number-format: "didid"; /* ideographic "place" separators and
>> no change to decimal market. Perhaps in Western scripts this
>> one is the same as adding commas or localized equiv.?  */
> I'd suggest
> Number-format: d千d百d十d;

I'm no expert on writing in Kanji/Chinese. Would you need to also
indicate characters for ten thousand, million, billion, etc. too? Or
are is it unambiguous once you've gone this far (aside from the
different ways to write "3").
Received on Sunday, 31 October 2010 07:01:51 UTC

This archive was generated by hypermail 2.3.1 : Wednesday, 21 September 2016 22:37:32 UTC