ExcelBanter - Changing $ format to a written format

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Changing $ format to a written format (https://www.excelbanter.com/excel-worksheet-functions/232355-changing-%24-format-written-format.html)

JGW

Changing $ format to a written format

Is there a formula that will take a dollar figure such as $15,231.23 in one
cell and have the written value of that cell to another? If the dollar
amount is in a1, can the result be fifteen thousand two hundred thirty one
dollars and 23/100 cents be in a2?
--
Julia

Jacob Skaria

Changing $ format to a written format

You will have to use a macro. Refer

http://www.ozgrid.com/VBA/CurrencyToWords.htm

If this post helps click Yes
---------------
Jacob Skaria

"JGW" wrote:

Is there a formula that will take a dollar figure such as $15,231.23 in one
cell and have the written value of that cell to another? If the dollar
amount is in a1, can the result be fifteen thousand two hundred thirty one
dollars and 23/100 cents be in a2?
--
Julia

fake_be

Changing $ format to a written format

Hi Julia,

Check out this VBA code. Copy it via the right click on the sheettab
insert the code.

http://www.ozgrid.com/VBA/ValueToWords.htm

Then use the =SpellNumber(A1) function whereas A1 is the cell
reference.

Good Luck,
Tom
On 29 mei, 16:41, JGW wrote:
Is there a formula that will take a dollar figure such as $15,231.23 in one
cell and have the written value of that cell to another? *If the dollar
amount is in a1, can the result be fifteen thousand two hundred thirty one
dollars and 23/100 cents be in a2?
--
Julia

All times are GMT +1. The time now is 09:09 AM.