| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to change figures into words
1) I bid projects that require me to list hundreds of unit prices in "BOTH"
words and figures. I know there's a formula that can create the figures "in words" from a numerical cell value, but can't find it. Help save me from writer's cramp! -- Dave H |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to change figures into words
Hi,
There's lots of them and this is as good as any. http://www.ozgrid.com/VBA/ValueToWords.htm Mike "Dave Hebert" wrote: 1) I bid projects that require me to list hundreds of unit prices in "BOTH" words and figures. I know there's a formula that can create the figures "in words" from a numerical cell value, but can't find it. Help save me from writer's cramp! -- Dave H |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to change figures into words
A Function rather than a Formula, but try this
http://support.microsoft.com/default...b;en-us;213360 Mike "Dave Hebert" wrote: 1) I bid projects that require me to list hundreds of unit prices in "BOTH" words and figures. I know there's a formula that can create the figures "in words" from a numerical cell value, but can't find it. Help save me from writer's cramp! -- Dave H |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to change figures into words
http://www.xldynamic.com/source/xld.xlFAQ0004.html
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dave Hebert" wrote in message ... 1) I bid projects that require me to list hundreds of unit prices in "BOTH" words and figures. I know there's a formula that can create the figures "in words" from a numerical cell value, but can't find it. Help save me from writer's cramp! -- Dave H |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to change figures into words | Excel Discussion (Misc queries) | |||
| Formula: figures to words | Excel Discussion (Misc queries) | |||
| formula which can convert amount in figures to amt in words | Excel Worksheet Functions | |||
| is it possible to get a formula for words or figures to "flash" | Excel Worksheet Functions | |||
| How do I change automatically figures into words in Excel | Excel Worksheet Functions | |||
Linear Mode
