close

I need to get the name of a number. For example: I have in A1 cell a value,
25 and I need its name in the next cell B1, I mean, I need to get into B1
cell the text saying quot;Twenty fivequot;. Do you know if ther is a function to do
this? or something else? thanks.


support.microsoft.com/default...;EN-US;Q213360--
MageeStringer
------------------------------------------------------------------------
MageeStringer's Profile: www.excelforum.com/member.php...oamp;userid=33298
View this thread: www.excelforum.com/showthread...hreadid=532491
codebetter.com/blogs/ranjan.s.../05/41854.aspx

here one that doe not convert to dollars

it's called convert to text
when you paste the function into a module the formula will be

=ConvertToText(A1)--
MageeStringer
------------------------------------------------------------------------
MageeStringer's Profile: www.excelforum.com/member.php...oamp;userid=33298
View this thread: www.excelforum.com/showthread...hreadid=532491

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()