Change valua into text ?

's Computer Specifications

Hello Excellers,

I wonder if it's possible to change a valua (1000) into text (THOUSAND) with
a formula or VBA ? Is there anyone who can help me with this pls.

Thanks Reijer

's Computer Specifications

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

"Reijer" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hello Excellers,
>
> I wonder if it's possible to change a valua (1000) into text (THOUSAND)
> with a formula or VBA ? Is there anyone who can help me with this pls.
>
> Thanks Reijer
>

's Computer Specifications

Thanks, this helped me a lot.

Greetzz Reijer.

"Reijer" <(E-Mail Removed)> schreef in bericht
news:%(E-Mail Removed)...
> Hello Excellers,
>
> I wonder if it's possible to change a valua (1000) into text (THOUSAND)
> with a formula or VBA ? Is there anyone who can help me with this pls.
>
> Thanks Reijer
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Getting in xcel in 1 cell txt valua based on number in other cell	jack van oorsouw	Microsoft Excel Programming	3	14th Jan 2011 12:08 PM
Change background color in one text box based on text in 2nd text	Gnerks	Microsoft Access Reports	4	4th Aug 2008 02:52 PM
Valua of a cel as message in a MsgBox	Reijer	Microsoft Excel Discussion	4	20th Nov 2006 12:57 PM
Change status bar text back to default 5 seconds after every change?	sherifffruitfly	Microsoft C# .NET	4	13th Nov 2006 10:59 PM
Problem in getting value from textbox & radiobuttonlist to a valua	=?Utf-8?B?dmVsdQ==?=	Microsoft ASP .NET	5	20th Sep 2005 04:32 PM