Search : in
By :

Figure conver to words in excel format

Last answer on Nov 1, 2009 9:17:02 am GMT Haris, on Jul 5, 2009 5:15:25 pm BST 
 Report this message to moderators

Hello,
What is formula for Figure to words in excel format
(Eg: Type "10" The receive next cell "TEN")

Thanking
yours faithfully

Haris

Configuration: Windows XP
Safari 530.5

Best answers for « Figure conver to words in excel format » in :
Basic Excel Formulas Show Basic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Download Ms Word Excel Cracker Show Ms Word Excel Craker allows recover lost or forgotten passwords for .xls and .doc reated with Microsoft Office 97, 2000, 2003, XP or other word and excel compatible programs. This application will be necessary in case you should have received an...
Basic Excel Formulas 2 ShowBasic Excel Formulas 2 We saw the SI function Function and is also interesting. Combined with SI, this gives: = IF (AND (condition1; condition2 ;....... conditionZ) true false) displays on the various conditions to be verified (eg...
Excel – Formula for cell calculation ShowExcel – Formula for cell calculation Issue Solution Note Issue Simple formula of =J3-SUM(L3:X3) BUT if J3 is empty then I want the formula to run as =C3-SUM(L3:X3) What is the proper formula to get the calculation to utilize J3 if...
How to convert Excel into PDF? ShowHow to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
Download Free PowerPoint/PPT to Pdf Converter ShowIt is frequent to convert Word, Excel or image files to PDF format. But it is not very common to convert a PowerPoint file to the PDF format. PowerPoint / PPT to Pdf Converter is an application allowing to convert easily and quickly PowerPoint...
Download Free Word/Doc Txt to Image Jpg/Jpeg Bmp Tiff Png ShowIt is usually the images that we insert into Word, Excel or PowerPoint documents. This time, it is the opposite, because we are going to convert these documents to image formats. All to Jpg / JPEG Image Bmp Tiff Png Converter is a powerful tool which...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...

1

venkat1926, on Jul 6, 2009 2:12:35 am BST
  • +2

There are third part add in for excel (Longre) calle "Moreucntions" which ahs number very good function. If you donwload this addin file and isntal as addin then when click insert function you will get one item more function in this there is a function called NBtext with some arguments this will convert your 10 into ten

http://xcell05.free.fr/english/index.html

Reply to venkat1926

2

dany, on Jul 27, 2009 9:58:15 am BST
  • +1

I dowlowded the excel ad in but not able to use it .
kindly please tel how to use it

Reply to dany

3

venkat1926, on Jul 27, 2009 10:30:07 am BST
  • +3

Select an empty cell. if you clicck fx before the formula bar you will get the name of the functions
click the arrow next to "or select category" you wii get "morefunc"
you will get a number of functions and among them is "NBTEXT"
see the explanation below. so this is the function . highlight it and you will get many arguments. only first two or important for many purposes. do some experiments.

in A1 type 122
in some other empty cell copy paste this formula
==NBTEXT(A1,2)
here 2 is "English"
you will get
one hundred and twenty two.

there may be other arguments.

Reply to venkat1926

4

venkat1926, on Jul 27, 2009 10:40:05 am BST
  • +2

I hope you have added this addin. You must be knowing how to add an addin
open a workbook and a sheet
click tools-addins
click browse goto the file where you have parked this more function excel file and click ok
you will get the morefunc in the list of addins. tick it in the square left of it if it is not alrady done.

Reply to venkat1926

5

 Bhandari, on Nov 1, 2009 9:17:02 am GMT

<gras>I wanr rupees to convert to words send any formula to my mail

Reply to Bhandari