Thread: Need a function to convert value in its name
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MageeStringer
 
Posts: n/a
Default Need a function to convert value in its name

http://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: http://www.excelforum.com/member.php...o&userid=33298
View this thread: http://www.excelforum.com/showthread...hreadid=532491

Reply With QuoteReply With Quote