Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KVS KVS is offline
external usenet poster
 
Posts: 1
Default How to Spell Number in English? I mean write 1 & see One?

I want to enter the number in one cell & see the English number in words in
the other formulated cell. What is the Forulla? how to write it?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default How to Spell Number in English? I mean write 1 & see One?

Please refer http://www.ozgrid.com/VBA/CurrencyToWords.htm

If this post helps click Yes
---------------
Jacob Skaria

"KVS" wrote:

I want to enter the number in one cell & see the English number in words in
the other formulated cell. What is the Forulla? how to write it?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,766
Default How to Spell Number in English? I mean write 1 & see One?

Hi,

You can also download the xlmore func addin and then use the NBTEXT()
function.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"KVS" wrote in message
...
I want to enter the number in one cell & see the English number in words
in
the other formulated cell. What is the Forulla? how to write it?


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
spell number N V Siva Prasad. Excel Discussion (Misc queries) 1 November 9th 07 04:38 PM
HOW TO WRITE NUMBERS IN WORDS(ENGLISH) exel general group Excel Discussion (Misc queries) 4 September 15th 07 05:31 AM
Digits spell it out in english using smart tag Smart tag Excel Worksheet Functions 1 July 6th 06 04:23 PM
how i convert to arbic number from english number ? Nabil Said Excel Discussion (Misc queries) 1 January 22nd 06 11:41 AM
Spell number vishu Excel Discussion (Misc queries) 3 February 24th 05 04:29 AM


All times are GMT +1. The time now is 03:09 AM.

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"