Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default SPELL NUMBER IN ENGLISH i.e 1,000 RESULT IS ONE THOUSAND ONLY

i am searching a formula

e.g
i write any value like 1000
the result is come (One thousand Only)
i write any value like 50000
the result is come (fifty thousand Only)
the formula result vary when value change

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default SPELL NUMBER IN ENGLISH i.e 1,000 RESULT IS ONE THOUSAND ONLY

Not a formula, but take a look at
http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"JAWAD CHOHAN" <JAWAD wrote in message
...
i am searching a formula

e.g
i write any value like 1000
the result is come (One thousand Only)
i write any value like 50000
the result is come (fifty thousand Only)
the formula result vary when value change



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
Using english and non-English Excel commands simultaneously in anon-English installation Michael.Tarnowski Excel Worksheet Functions 6 March 12th 10 07:21 AM
Translate any english number into English word SANTANU Excel Discussion (Misc queries) 2 March 4th 10 04:42 PM
How to Spell Number in English? I mean write 1 & see One? KVS Excel Worksheet Functions 2 March 18th 09 12:53 PM
Digits spell it out in english using smart tag Smart tag Excel Worksheet Functions 1 July 6th 06 04:23 PM
How can I format number into thousand? Roni Excel Worksheet Functions 2 October 9th 05 05:51 PM


All times are GMT +1. The time now is 04:49 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"