Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Formula
Is there a formula in Excel that will take the value, 1,000 and put it into
words, such as One Thousand and no/100--------- . Obviously I am trying to use this for checks, and I want the text field to look at the value in a cell, and transform it into words. |
#2
|
|||
|
|||
go here and get rons google addin and search for numbers to words. LOTS of
hits. http://www.rondebruin.nl/ -- Don Guillett SalesAid Software "Shelly9633" wrote in message ... Is there a formula in Excel that will take the value, 1,000 and put it into words, such as One Thousand and no/100--------- . Obviously I am trying to use this for checks, and I want the text field to look at the value in a cell, and transform it into words. |
#3
|
|||
|
|||
The following may be helpful.
http://support.microsoft.com/default...B;EN-US;213360 Alok "Shelly9633" wrote: Is there a formula in Excel that will take the value, 1,000 and put it into words, such as One Thousand and no/100--------- . Obviously I am trying to use this for checks, and I want the text field to look at the value in a cell, and transform it into words. |
#4
|
|||
|
|||
Thank you very much, Don. I found exactly what I was looking for.
"Don Guillett" wrote: go here and get rons google addin and search for numbers to words. LOTS of hits. http://www.rondebruin.nl/ -- Don Guillett SalesAid Software "Shelly9633" wrote in message ... Is there a formula in Excel that will take the value, 1,000 and put it into words, such as One Thousand and no/100--------- . Obviously I am trying to use this for checks, and I want the text field to look at the value in a cell, and transform it into words. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does Excel show a formula in ONE cell ? | Excel Discussion (Misc queries) | |||
Excel CHALLENGE...3 questions(indirect,rank,array formula)... | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions |