Excel: convert numeric into alphabet

April 2017

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


Published by aakai1056. Latest update on March 18, 2012 at 04:19 PM by Virginia Parsons.
This document, titled "Excel: convert numeric into alphabet," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).