Is it possible to make microsoft excel automatically display a number in written

[darshans]

Is it possible to make microsoft excel automatically display a number in written?

What i mean is if i have a cell say C2 having value as 76 can i somehow make it display as Seventy Six.

 

[shrivallabha]

Hi there are many such functions available. Google with following criteria Excel+Convert+Number+To+Words


You'll get links like this in response:

http://support.microsoft.com/kb/213360

 

[shrivallabha]

Today, someone else also requested the same thing.


Please take a look at UDF posted by SGMPatnaik.

http://chandoo.org/forums/topic/spell-the-number


Hth,