Thread: Convert a number to a text string
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Convert a number to a text string
See Bob Phillips' site for methods.

http://www.xldynamic.com/source/xld.xlFAQ0004.html


Gord Dibben MS Excel MVP

On Thu, 3 Jan 2008 11:30:01 -0800, Sandy
wrote:

I want to convert a number like 12.56 to read Twelve Dollars and 56/100

Reply With QuoteReply With Quote