Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE
HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE in excel any verson
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE
???????????
-- Kind regards, Niek Otten Microsoft MVP - Excel "bkr" wrote in message ... HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE in excel any verson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE
Hi,
Please, do not use capitals for posting your question. If you mean: how to enter a value as text, use ' e.g. '4 Wkr, JP "bkr" wrote in message ... HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE in excel any verson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE
Niek
Maybe numbers to words? http://www.xldynamic.com/source/xld.xlFAQ0004.html Gord Dibben MS Excel MVP On Sat, 29 Aug 2009 17:56:01 +0200, "Niek Otten" wrote: ??????????? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE
Hi,
You can get free code to convert numerical entries to text, such as 123 to One Hundred Twenty Three, at the following web site: http://support.microsoft.com/kb/213360 -- If this helps, please click the Yes button. Cheers, Shane Devenshire "bkr" wrote: HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE in excel any verson |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE
Hello,
http://www.xldynamic.com/source/xld.xlFAQ0004.html (the VBA code) returns for 1000000000000000 "One Dollar Only" 0.123 "Dollars And 12" Microsofts site http://support.microsoft.com/default...b;en-us;213360 returns for 1000000000000000 "Hundred Fifteen Dollars and No Cents" -20.123 "Hundred Twenty Dollars and Twelve Cents" In my humble opinion you should NOT use these programs because they do not apply a proper parameter check. I suggest to use http://www.sulprobil.com/html/spellnumber.html instead or to use Rick's code. His one seems to work fine as well. Regards, Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format .txt file contents to numeric format will not work - help! | Excel Discussion (Misc queries) | |||
Converting values which are in Numeric format to word format | Excel Discussion (Misc queries) | |||
Need to test for alphanumeric value and write numeric values to ce | Excel Worksheet Functions | |||
can i write a macro to truncate alpha-numeric data? | Excel Discussion (Misc queries) | |||
Change number (in text format) to numeric format | Excel Discussion (Misc queries) |