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

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

متابعة

How to convert digits into words in excel?

user-image
تم إضافة السؤال من قبل Parthiban Kothandapani , Quantity Surveyor , A Reputed Construction Company.
تاريخ النشر: 2016/01/16
SREEJITH SREEKUMAR INDIRADEVI
من قبل SREEJITH SREEKUMAR INDIRADEVI , Sr.Accountant , YAQUBY STORES WLL

 Use SpellNumber macro in your worksheets. Now you can use the function SpellNumber in your Excel documents. Enter =SpellNumber(A2) into the cell where you need to get the number written in words. Here A2 is the address of the cell with the number or amount

Karthik B Nair
من قبل Karthik B Nair , Senior Planning Engineer , Meydan Shobha Construction

The above answers could be used, but keeping it simple since the actual purpose is not clear, one option is the Text function. This enables you to display the text in the format you need (just to a search in excel help for the formats types).

saif alatabby
من قبل saif alatabby , site engineer , Burj alarab

=CONCATENATE(TEXT(UPPER(Spell Number(B6)),0),"ONLY")

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