How to convert values in to text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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.
 
This doen't converts the number to words

Paul Mathews said:
=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)
Click to expand...
 
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).
 
Back
Top