similar syntax from microsft word "\*DollarText" which converts numbers into their corresponding text format. Example: 1,234.50 is converted to ONE THOUSAND TWO HUNDRED THIRTY FOUR AND 50/100.

Asked by Naushad KV on 2010-08-25

similar syntax from microsft word "\*DollarText" which converts numbers into their corresponding text format. Example: 1,234.50 is converted to ONE THOUSAND TWO HUNDRED THIRTY FOUR AND 50/100.

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
2010-08-25
Last reply:
2010-08-25
Tony Pursell (ajpursell) said : #1

Hi

There is an extension for Calc that you can download called Numbertext 0.9.1 from

http://extensions.services.openoffice.org/en/node/4063

For instance, it will convert 1234.5 in A1 to "one thousand two hundred and thirty-four point five" (with the formula (=NUMBERTEXT(A1,"en-US") so you will have to do a bit of manipulation to get the cents the way you want them.

Tony

PS If this answers your question, please mark it as Solved.

Tony Pursell (ajpursell) said : #2

Full Formula

=CONCATENATE(UPPER(NUMBERTEXT(INT(A1)))," AND ",TEXT((A1-INT(A1))*100,"##"),"/100")

Can you help with this problem?

Provide an answer of your own, or ask Naushad KV for more information if necessary.

To post a message you must log in.