ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

How to convert numbers or figures into words?

user-image
تم إضافة السؤال من قبل George Changayil Thomas , Accountant , Almulla Group
تاريخ النشر: 2014/10/24
مستخدم محذوف‎
من قبل مستخدم محذوف‎

If you literally want to convert nos to words then you can use the 'SpellNumber' function by adding it through the VB Editor.

If you are looking to add alphanumeric or some other content to a cell then you need to format that cell to text. It can be done by adding a ' before the content to be entered.

Johnny Anthony
من قبل Johnny Anthony , Executive Secretary , Indusmens Corporation

To convert a numeric value into an English word, here is the formula you will need a numeric into english work

Example:

1. Press Alt+F11 > copy and paste in module (if module does not show insert module, click insert on menu bar >

 

Module)2. Alt+Q Save code and return to Excel sheet3. Insert > function > user defined > A1 or relevant cell.

FITAH MOHAMED
من قبل FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

In Excel 

There is no  a direct function of the expression of the figures in words 

But i use one made by micro  belong to  "abo hagr "

someone  who  made    micro function to convert numbers to words, but only in Arabic

 

it called "Altfiqit function " you can search for it by google by arabic words 

in the down  comment 

Atif Tanveer
من قبل Atif Tanveer , Decision Support Specialist , Hamilton Health Science

add a ' in beginning '1234 

المزيد من الأسئلة المماثلة