Thread: CONVERTING NUMBERS TO TEXT
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default CONVERTING NUMBERS TO TEXT
Download and install the free add-in Morefunc.xll from:
http://www.download.com/Morefunc/300...-10423159.html

....then use this formula

=NBTEXT(A1)



"Briggs" wrote:

How can I convert numbers to text? I get how to convert text to numbers, but
can't seem to convert numbers to text.
--
Briggs
Reply With QuoteReply With Quote