howto convert a number into words like 10 to ten

kaushik · External Since: Aug 31, 2006 Posts: 4

i want to print numbers entered as numbers in words like 1 is one,20 as
twenty also to have two decimal places

Paul B · External Since: Nov 03, 2004 Posts: 1078

kaushik, have a look here,
http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"kaushik" <kaushik DeleteThis @discussions.microsoft.com> wrote in message
news:F526CD1E-90D0-4006-AD7E-3A2E13D588D8@microsoft.com...
> i want to print numbers entered as numbers in words like 1 is one,20 as
> twenty also to have two decimal places

kaushik · External Since: Aug 31, 2006 Posts: 4

thanks it helps

"Paul B" wrote:

> kaushik, have a look here,
> http://www.xldynamic.com/source/xld.xlFAQ0004.html
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "kaushik" <kaushik.DeleteThis@discussions.microsoft.com> wrote in message
> news:F526CD1E-90D0-4006-AD7E-3A2E13D588D8@microsoft.com...
> > i want to print numbers entered as numbers in words like 1 is one,20 as
> > twenty also to have two decimal places
>
>
>

Andy Wiggins · External Since: Aug 28, 2006 Posts: 21

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip

It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains the "SPELLNUMBER" function, which can be used in your
spreadsheets, two methods to convert numbers to words and two cheque
writing routines.

The code is open and commented.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"kaushik" <kaushik.RemoveThis@discussions.microsoft.com> wrote in message
news:F526CD1E-90D0-4006-AD7E-3A2E13D588D8@microsoft.com...
>i want to print numbers entered as numbers in words like 1 is one,20 as
> twenty also to have two decimal places

kaushik · External Since: Aug 31, 2006 Posts: 4

Thanks Andy I think this will do the job

"Andy Wiggins" wrote:

> This file might be a help:
> http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip
>
> It's in the "Accountants" section on page:
> http://www.bygsoftware.com/examples/examples.htm
> It contains the "SPELLNUMBER" function, which can be used in your
> spreadsheets, two methods to convert numbers to words and two cheque
> writing routines.
>
> The code is open and commented.
>
>
> --
> Andy Wiggins FCCA
> www.BygSoftware.com
> Excel, Access and VBA Consultancy
> -
>
>
> "kaushik" <kaushik.TakeThisOut@discussions.microsoft.com> wrote in message
> news:F526CD1E-90D0-4006-AD7E-3A2E13D588D8@microsoft.com...
> >i want to print numbers entered as numbers in words like 1 is one,20 as
> > twenty also to have two decimal places
>
>
>

Ibrahim · External Since: Jan 29, 2007 Posts: 7

"kaushik" wrote:

> i want to print numbers entered as numbers in words like 1 is one,20 as
> twenty also to have two decimal places

Ibrahim · External Since: Jan 29, 2007 Posts: 7

"Paul B" wrote:

> kaushik, have a look here,
> http://www.xldynamic.com/source/xld.xlFAQ0004.html
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "kaushik" <kaushik.TakeThisOut@discussions.microsoft.com> wrote in message
> news:F526CD1E-90D0-4006-AD7E-3A2E13D588D8@microsoft.com...
> > i want to print numbers entered as numbers in words like 1 is one,20 as
> > twenty also to have two decimal places
>
>
>

Ibrahim · External Since: Jan 29, 2007 Posts: 7

"Andy Wiggins" wrote:

> This file might be a help:
> http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip
>
> It's in the "Accountants" section on page:
> http://www.bygsoftware.com/examples/examples.htm
> It contains the "SPELLNUMBER" function, which can be used in your
> spreadsheets, two methods to convert numbers to words and two cheque
> writing routines.
>
> The code is open and commented.
>
>
> --
> Andy Wiggins FCCA
> www.BygSoftware.com
> Excel, Access and VBA Consultancy
> -
>
>
> "kaushik" <kaushik.RemoveThis@discussions.microsoft.com> wrote in message
> news:F526CD1E-90D0-4006-AD7E-3A2E13D588D8@microsoft.com...
> >i want to print numbers entered as numbers in words like 1 is one,20 as
> > twenty also to have two decimal places
>
>
>