Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing format | Excel Discussion (Misc queries) | |||
format numbers in written form | Excel Discussion (Misc queries) | |||
Keeps changing the format | Excel Discussion (Misc queries) | |||
Changing the format of a column | Excel Discussion (Misc queries) | |||
Changing format of number without changing the value | Excel Discussion (Misc queries) |