Thread: Identifying Numeric Values within a Range Formatted as Text

Originally Posted by pcperv

I have the same question as the rest. I would like to know the solution to the problem.

numerical value:

1,754.25

convert to:

One Thousand Seven Hundred Fifty-four and 25/100

Please reply at my e-mail: pcperv.pico@gmail.com

Thanks.

Here are a number of links for the code to convert numbers to text

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

http://support.microsoft.com/default...;EN-US;Q213360

http://xcell05.free.fr/english/morefunc/nbtext.htm

In your particular case you need to separate the whole number from the decimal by firstly using

=ROUNDDOWN(A1,0) in cell B1 and

=RIGHT(A1,2)&"/100" in cell C1, if you use the first link for your code then you could CONCATENATE this onto

=SpellNumber(B1)&" and "&C1