| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Written number amounts
is it possible in excel to input a number (5) and produce/convert it to a
written amount (five)? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Written number amounts
=CHOOSE(A1+1,"zero","one","two","three","four","fi ve","six","seven","eight","nine",)
-- Gary''s Student - gsnu200903 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Written number amounts
See article entitled "How to convert a numeric value into English words in
Excel" http://support.microsoft.com/kb/213360 -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "ajchapaiii" wrote: is it possible in excel to input a number (5) and produce/convert it to a written amount (five)? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Written number amounts
thanks, however i needed something a bit more advance. What luke m submitted
was exactly what i needed "Gary''s Student" wrote: =CHOOSE(A1+1,"zero","one","two","three","four","fi ve","six","seven","eight","nine",) -- Gary''s Student - gsnu200903 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Written number amounts
this worked great
"Luke M" wrote: See article entitled "How to convert a numeric value into English words in Excel" http://support.microsoft.com/kb/213360 -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "ajchapaiii" wrote: is it possible in excel to input a number (5) and produce/convert it to a written amount (five)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding amounts that sum to a number | Excel Discussion (Misc queries) | |||
| Identify if Cell is Formula or written number | Excel Worksheet Functions | |||
| how to account the number of cells which is bank and written? | Excel Discussion (Misc queries) | |||
| How do I convert Amounts written in figures to words ? | Excel Discussion (Misc queries) | |||
| Is there a formula to change number value to the written value? | Excel Discussion (Misc queries) | |||
Linear Mode
