Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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

user-image
Question ajoutée par VIJAY CV , Finance And Admin Manager , Smart City Systems
Date de publication: 2014/10/27
Randolph Estipular
par 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
par 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
par Ednalyn Banuelos, CMA , Projects Accountant , Grade Ref., LLC

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

Utilisateur supprimé
par Utilisateur supprimé

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