Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

Is it possible to convert numbers into words in a cell by using MS Excel formula or function? How?

user-image
Question ajoutée par Imran Ahmed , Manager-Planning & Delay Analyst , Nesma United Industries (NUI) Saudi Arabia
Date de publication: 2016/09/26
WAHYU ADHI NUGROHO
par WAHYU ADHI NUGROHO , Project Leader , PT. MULYAINDRA PRIBADI

Yes, it is,,We can do by using the formula VB or macros, or by using the main functions of the IF and VLOOKUP.

shamshad abdul salam
par shamshad abdul salam , Payroll Coordinator , Rashed Abdulrahman Alrashed

Yah, it is possible to convert numbers into words in a particular cell using MS Excel formula

Yes.. You may use "Spellnum function" but you need to insert a module in the specific sheet or workbook. This might help you. https://support.microsoft.com/en-us/kb/213360

Philip Adoyo
par Philip Adoyo , Support Executive , Seven Solutions Limited

Yes. It is possible to do so especially when you are working on a combination worksheet and need to tabulate financials with accruals and returns.

 

Barton Bersabal
par Barton Bersabal , EXPORT SALES COORDINATOR , SFFECO GLOBAL FZE

Yes, by using VB and Modue

Utilisateur supprimé
par Utilisateur supprimé

Yes, first determine the second column currency number format Third, go to the Data menu and clicking on the text columns and choose Fourth end and Excel will change the numbers

Firas Shahadi
par Firas Shahadi , Human Resources Director , SAUDI UNION

Please check this

https://support.microsoft.com/en-us/kb/213360

Regards

Tharwa Haddadin
par Tharwa Haddadin , Director of Business Audit , Social Security Corp.

Yes it is, we can by  "Spellnum function" , we need to insert a module in the specific sheet or workbook.

Ana Lea Casauay
par Ana Lea Casauay , Collection Assistant , Global City Car Lease & Transport Corp (Click Auto Rental & Leasing) A member of Autohub Group of Companies

YES. 

  1. Select the cell that you want.
  2. Click Insert Function on the Standard toolbar.
  3. Under Or select a category, click User Defined.
  4. In the Select a function list, click SpellNumber, and then click OK.
  5. Enter the number or cell reference that you want, and then click OK.

Gulam Ahmed Syed
par Gulam Ahmed Syed , Business Unit Manger , Perform ICT

Yes, using TEXT funtion. Its syntax is

=TEXT(Value, Format)

 

Value can be constant or cell reference

 

Example 

1. =TEXT(345, "0") 

returns 345. cell format will be text. You can see it left aligned. Numbers are Right aligned.

 

Alternative way without using function

Select the cell(s) containing number(s) , Right-Click to access short cut menu, Select Format Cells, From the Category list select Text , Click OK button

 

 

More Questions Like This