Ubuntu
openoffice.org package

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

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:
Last reply:
Revision history for this message
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.

Revision history for this message
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.