Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bkr bkr is offline
external usenet poster
 
Posts: 1
Default HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE

HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE in excel any verson
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,440
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 174
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,346
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 806
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format .txt file contents to numeric format will not work - help! Tacrier Excel Discussion (Misc queries) 3 October 7th 08 10:00 PM
Converting values which are in Numeric format to word format Frnc Excel Discussion (Misc queries) 1 July 2nd 08 08:42 AM
Need to test for alphanumeric value and write numeric values to ce Pyramid 36 Excel Worksheet Functions 3 August 3rd 07 03:15 AM
can i write a macro to truncate alpha-numeric data? T-Dot Excel Discussion (Misc queries) 2 August 12th 06 08:15 AM
Change number (in text format) to numeric format Pam Excel Discussion (Misc queries) 5 October 24th 05 07:45 PM


All times are GMT +1. The time now is 09:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"