Excel: convert numeric into alphabet

December 2016

Microsoft Excel is an integral part of Microsoft office software. It is a very versatile software serving a lot of purposes. There are a number of functions that can be served using the Microsoft Excel software application. A large number of formulae, relationships and functions are provided in Excel which are helpful in creating databases, log tables and many more. For users who face problems in converting numeric into alphabet while using Microsoft Excel, there is a simple step that needs to be followed to solve the issue. It is required to simply use the '=words (RANGEADDRESS)' to find out the number of words used in the workbook.

Issue


I just want to know how I can convert numeric into alphabet in Excel. Can you send me a formula of that particular criteria please?

Solution



Get Rajput's code here: http://ccm.net/...

Then use
=words(RANGEADDRESS)
to get the number in words in the workbook.

Note


Thanks to Excelguru for this tip on the forum.

Related :

This document entitled « Excel: convert numeric into alphabet » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.