Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default convert digits in words

if i wrote some sum like 2,000 dollars how i can change in words "two
thousand dollars"
--
MoinnioM
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default convert digits in words

a.. http://support.microsoft.com/kb/213360
a.. http://www.xldynamic.com/source/xld.xlFAQ0004.html
a.. http://www.ozgrid.com/VBA/ValueToWords.htm
--
David Biddulph

"moin" wrote in message
...
if i wrote some sum like 2,000 dollars how i can change in words "two
thousand dollars"
--
MoinnioM



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default convert digits in words

Hi Moin

You will have to use a macro to achieve this. Refer the below link

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

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


"moin" wrote:

if i wrote some sum like 2,000 dollars how i can change in words "two
thousand dollars"
--
MoinnioM

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
How to convert digits into text Naseem Excel Worksheet Functions 2 August 19th 08 09:14 PM
how to convert numeric to words Example 525 in words (Twenty five Ganta Amar Nath Excel Discussion (Misc queries) 2 July 17th 08 10:21 AM
How to convert the values into 3 digits? Eric Excel Discussion (Misc queries) 5 February 2nd 08 10:23 PM
Convert string of digits into a date Scott Lolmaugh Excel Worksheet Functions 1 February 23rd 06 09:43 PM
Formula Convert Digits to Words (1000 write One thousand) Excel Excel Worksheet Functions 3 November 27th 05 12:02 PM


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