Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Function/Formula for Text Conversion

Is there any formula/function to convert a numeric value to text?
e.g. I want to convert a numeric number, e.g 250, to a text.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default Function/Formula for Text Conversion

See:

http://support.microsoft.com/default...EN-US;Q213360&


--
Gary''s Student - gsnu200809


"Rauf" wrote:

Is there any formula/function to convert a numeric value to text?
e.g. I want to convert a numeric number, e.g 250, to a text.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default Function/Formula for Text Conversion

have a look here

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

Mike

"Rauf" wrote:

Is there any formula/function to convert a numeric value to text?
e.g. I want to convert a numeric number, e.g 250, to a text.

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,718
Default Function/Formula for Text Conversion

Download and install the free add-in Morefunc.xll from:
http://xcell05.free.fr/

=NBTEXT(A1)


"Rauf" wrote:

Is there any formula/function to convert a numeric value to text?
e.g. I want to convert a numeric number, e.g 250, to a text.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conversion function for Bytes RORWessels Excel Discussion (Misc queries) 2 April 4th 23 12:46 PM
Conversion of Numbers into Text Miki Excel Discussion (Misc queries) 3 August 20th 08 07:28 PM
Date to text conversion ginnyst Excel Discussion (Misc queries) 4 December 7th 07 03:32 PM
Metric conversion formula / function Paula ) Excel Discussion (Misc queries) 3 September 6th 07 04:23 AM
PV function conversion to SQL [email protected] Excel Discussion (Misc queries) 1 November 20th 05 03:37 PM


All times are GMT +1. The time now is 04:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"