Value in words

[Rahul Mishra]

Dear Sir,
How i can wright 90 = (ninety) in excel without vba

 

[Chihiro]

You'll need to create lookup table.

However it is best done via VBA (UDF or some other method).

 

[Syedali]

Dear Sir,
How i can wright 90 = (ninety) in excel without vba

Hi,

With VBA it is possible. No idea about without VBA... If anyone knows and posted here it will be very useful to all Excel Lovers.

 

[Marc L]

Hi !

Without VBA, a worksheet helper with two columns :
one for the number (90) and another for the word (ninety)
and the conversion is operated via a simple VLOOKUP formula …

Rahul, the other way : a direct input, it well works !
​

 

[Mike86]

How many numbers other than "ninety" do you need to write? Just one or two you could use something like:

=choose(90-89,"Ninety")

or

=if(a1=90,"Ninety","")