0
Thanks

A few words of thanks would be greatly appreciated.

Excel: convert numeric into alphabet

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.
0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
Jean-François Pillou

CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Learn more about the CCM team

Published by . Latest update on 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 (https://ccm.net/).

0 Comments