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
- Nov 21 Wed 2007 20:40
Need a function to convert value in its name
close
全站熱搜
留言列表
發表留言