Currency

[elsuave22]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hello There,

Im fairly new to excel, and i'm looking to see how can i create a way to convert numbers to text.

100.00 to "One Hundredth Dollars" on next cell?

 

[John McGhie]

Good question

I believe this is a function named "Ordinal Text" that Excel does not have.
Word has field codes that will do this, but Excel does not.

So I am sorry, but you will have to make it yourself, as a formula.

There are some ideas here:

http://www.dailydoseofexcel.com/archives/2004/07/19/ordinal-days/

Cheers

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
Hello There,

Im fairly new to excel, and i'm looking to see how can i create a way to
convert numbers to text.

100.00 to "One Hundredth Dollars" on next cell?

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

--

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]

 

[elsuave22]

Thank you John,

Well, in that case do you think i should ask the same question on the forum for Word?.

The thing is this, I Work for a Cruise Line, Carnival. and sometimes families of guests send them money so they can spend onboard while they are at sea. the payment comes to our main office and then i have to email the ship to let them know that this money is in. do this by way of email. and it becomes very monotone for me to be copy and pasting the same message over and over.

So what i'm looking for is to create a Form, with for example:
the ability to have a button that once i click on it, after i input all the pertinent information as to who is the money for, reservation number, amount of funds.($100.00 One Hundredth Dollars, cero cents) ect. it will be email to a specific mailbox.
I thought of various ways to have this done, and definitely i could ask for assistance of or developer in house, but i realize that this project is more of a convenience to myself. thought it could be done using sharepoint documents, or infopath but i do not know or have any of this programs available to me.

i'm learning as i go, an will love to learn more

 

[CyberTaz]

No offense, but I think John is being misled by your inclusion of the "th"
at the end of the word Hundred. The text should read "One Hundred Dollars,
zero cents". The "th" suggests fractional [such as "A penny is one
'hundredth' of a dollar." or ordinal [such as "The ship will dock on the 5th
(fifth) of the month."]

There is no function or feature within Excel (or any other Office program)
that will read a numerical value & convert it to the equivalent literal text
string. I'm afraid this is a far more complex operation than it may appear
to be on the surface.

Regards |:>)
Bob Jones
[MVP] Office:Mac