Ask Your Question

Spell Number

asked 2018-09-26 10:09:51 +0200

Emoh gravatar image

An amount, say 100,000.00, how to write into words One hundred thousand (currency) only.

edit retag flag offensive close merge delete


Which language do you want? As I know different English used different forms. For example "100011" will be "one hundred thousand eleven" for en_US and "one hundred thousand and eleven" for en_UK. In any case, you will need a macro, IMHO built-in tools still are not good enough.

JohnSUN gravatar imageJohnSUN ( 2018-09-26 11:45:33 +0200 )edit

I want English US

Emoh gravatar imageEmoh ( 2018-10-01 09:59:23 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-09-30 01:32:30 +0200

Well - there is a built-in solution now in 6.1 (see release notes).

Since you have used calc tag, then you would need to use the [NatNum12] 0 format string for your cells or cell styles.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-09-26 10:09:51 +0200

Seen: 70 times

Last updated: Sep 30 '18