Excel function to convert number to words

[Frank Kabel]

Hi
see your response in public.excel

 

[Mukesh Jain]

I am a newbie to Excel.I want to know the following things.

1.Is there any inbuilt function to convert an amount in numerical format to
amount in words (for ex,1144.56 to Thousand one hundred and forty four
dollars and cents fifty six) ?

2.Is there any way of making the formulas in a excel worksheet permament
(formulas get deleted when you delete data)so that they can be used as a
template.

3.Is there any way of building custom functions for performing the above
mentioned tasks?

Regards,
Mukesh

 

[Toby Erkson]

And since that title is different than this one, for those that want an
answer, look for the subject titled, "Functions to convert number to words".