Friday, 22 January 2016

How to Convert Numbers into Characters in Excel.

http://gllegalentity.blogspot.com/2016/01/how-to-convert-numbers-into-characters.html

For E.g.

99 (Numeric) converting it into (Character) Ninety Nine

I have Taken an Addin from some of my friend add it into excel and can convert Numbers into Characters easily. If you know any other way so please shares it with all.

1.  Download the file SConCurEng.Xla (Please send your Email Address on Inbox2tariq@gmail.com for the file)

2. Go to Excel Options > Add ins




Go to Manage and click on GO


Click on Browse


And attach the Downloaded file


Click ok
Go to Formulas on Excel
Navigate to Functions



Select a Category All


You will find the downloaded Add in
Press OK


\
write any Number in it
Press ok


If you know another way of how to convert numbers into Characters in Excel Please Share the Knowledge.

No comments:

Post a Comment