ExcelBanter - Function/Formula for Text Conversion

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Function/Formula for Text Conversion (https://www.excelbanter.com/excel-worksheet-functions/207638-function-formula-text-conversion.html)

Rauf

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.

Gary''s Student

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.

Mike H

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.

Teethless mama

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.

All times are GMT +1. The time now is 03:27 AM.