Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Suggest a simplest way to convert numbers to text in Microsoft excel other than using VB script.

user-image
Question added by VIJAY CV , Finance And Admin Manager , Smart City Systems
Date Posted: 2014/10/27
Randolph Estipular
by Randolph Estipular , Computer Operator at Saudia Airlines , Almajal Service Master

There is no other way sir, search spell number code in the internet and then paste it on VBA module in excel and type in the cell =SpellNumber(Cell# that yo want to spell).

Ahmed Maher allam
by Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions

to convert numbers to text u should use for example

=char(97)

which will gives u output small letter a. 

Ednalyn Banuelos, CMA
by Ednalyn Banuelos, CMA , Projects Accountant , Grade Ref., LLC

In the Format Cells under the Number Tab, click "Text" then press Ok. 

The best way I have found is =Value(Cell) I have used this within other formulas, for example in data validation, and it works well. You can also use it to get the excel value of a date for example.

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.