How to convert values in to text

I want to convert any numeric figure into text - for eg. 456 to Four hundred
fifty six - how do i do that in excel 2007

=VALUE(A1) where A1 holds the text string that looks like a number (this is
an Excel 2003 function which I presume hasn't changed in Excel 2007)

"Vineet" wrote:

> I want to convert any numeric figure into text - for eg. 456 to Four hundred
> fifty six - how do i do that in excel 2007

Hi again, if you were wanting to do a type conversion in VBA, you might want
to use something like cInt(TextStringVariable) or cLng, CSng, or CDbl
depending on what the text string number looks like.

"Vineet" wrote:

> I want to convert any numeric figure into text - for eg. 456 to Four hundred
> fifty six - how do i do that in excel 2007

This doen't converts the number to words

"Paul Mathews" wrote:

> =VALUE(A1) where A1 holds the text string that looks like a number (this is
> an Excel 2003 function which I presume hasn't changed in Excel 2007)
>
> "Vineet" wrote:
>
> > I want to convert any numeric figure into text - for eg. 456 to Four hundred
> > fifty six - how do i do that in excel 2007

Vineet, sorry, I read your posting the wrong way around. Try using the TEXT
function. For example TEXT(A1,"0") or TEXT(A1,"$0.00") if you want the
currency format (you can choose how you'd like to format the number).

"Vineet" wrote:

> This doen't converts the number to words
>
> "Paul Mathews" wrote:
>
> > =VALUE(A1) where A1 holds the text string that looks like a number (this is
> > an Excel 2003 function which I presume hasn't changed in Excel 2007)
> >
> > "Vineet" wrote:
> >
> > > I want to convert any numeric figure into text - for eg. 456 to Four hundred
> > > fifty six - how do i do that in excel 2007

check back through the archives for lots of posts on this subject, but
try

http://groups.google.co.uk/group/com...08330803795afc


Vineet wrote:
> I want to convert any numeric figure into text - for eg. 456 to Four hundred
> fifty six - how do i do that in excel 2007

Hello,

I suggest to take my function spellnumber from
http://www.sulprobil.com/html/spellnumber.html and to omit currency and
fractional output.

If you think of using another spellnumber function I seriously suggest
to test it with the input numbers shown on my page...

HTH,
Bernd