You mean like 3333.33 should be

Three Thousand Three Hundred And Thirty Three Dollars And Thirty three Cents

See Bob Phillips' site for methods.

http://www.xldynamic.com/source/xld.xlFAQ0004.html


Gord Dibben MS Excel MVP

On Thu, 11 Dec 2008 12:06:08 -0800, gangadhar
wrote:

please give some examples