View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default "1235" appears as "One thousand two hundred thirty five"

Numbers to words
Bob Phillips' site for help on this.

http://www.xldynamic.com/source/xld.xlFAQ0004.html

or Bernd Plumhoff's site

http://www.sulprobil.com/html/spellnumber.html

--------------------------------------------------------------------------------


--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Vinod Gaikwad" <Vinod wrote in message
...


"H. Kan" wrote:

please i want to know how i convert number to text in excel datasheet or
access

for example :
1235.75
one thousand two hundred thirty five and 75/100

thank you for your help