Communiquez avec les autres et partagez vos connaissances professionnelles

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

Suivre

How to convert digits into words in excel?

user-image
Question ajoutée par Parthiban Kothandapani , Quantity Surveyor , A Reputed Construction Company.
Date de publication: 2016/01/16
SREEJITH SREEKUMAR INDIRADEVI
par 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
par 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
par saif alatabby , site engineer , Burj alarab

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

More Questions Like This