Query

[shantanu]

Hi,
My question is If I do a calculation in a cell,
calculated number/ result comes. Will in another cell this
result come in words? For example 2 + 2=4 , will it come
as four.

 

[Jason Morin]

Currently there's no built-in feature to do this. You can
use Laurent Longre's add-in MOREFUN.XLL (install it under
Tools > Add-Ins) to translate numbers into words. You'll
find it at:

http://longre.free.fr/english/

Once installed, the function to use is NBTEXT.

HTH
Jason
Atlanta, GA

 

[JE McGimpsey]

See

http://www.mvps.org/dmcritchie/excel/strings.htm#numberstowords