convert 12345(figure) into word

i want to convert the figure 123456 into (english) word
I also want to group the digit like 12,25,458
Both the answer should be in excel

Grouping the digits is just formatting... select the cell(s) then Format >
Cells. Select the Number tab, and choose the Number category, set the
Decimal places to 0 and check 'Use 1000 Separator'.
To convert to text, check the Microsoft site and search for 'spellnumber:'
http://support.microsoft.com/default...b;en-us;213360
--Bruce

"Hirak Chatterjee" wrote:

> i want to convert the figure 123456 into (english) word
> I also want to group the digit like 12,25,458
> Both the answer should be in excel

See

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Hirak Chatterjee" <Hirak [email protected]> wrote in
message news:[email protected]...
> i want to convert the figure 123456 into (english) word
> I also want to group the digit like 12,25,458
> Both the answer should be in excel

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Hirak Chatterjee" <Hirak [email protected]> wrote in
message news:[email protected]...
> i want to convert the figure 123456 into (english) word
> I also want to group the digit like 12,25,458
> Both the answer should be in excel

Hi,
I have created a utlility that may help you
http://www.geocities.com/excelmarksw...ToLongText.xls

created: 10 August 2004. This utility converts numbers to its Long Text
Name. Example: 21 converts to twenty-one, 4002 converts to four thousand and
two. It only converts whole numbers. The following is exempt: Currency,
Decimals, Negatives. You can also send the result to a cell.



"Hirak Chatterjee" wrote:

> i want to convert the figure 123456 into (english) word
> I also want to group the digit like 12,25,458
> Both the answer should be in excel

Dear Sir,
I am very much obliged and grateful that you have created the program for me.

I am very much interested to learn program of Visual Basic and Java.

Would you kindly sendme something by which I can learn programming in visual
basic and java.

I have no basic idea about programming

would you kindly response in my appeal.

Thanks a lot and I will be obliged.

Hirak Chatterjee
India
West Bengal
Kolkata
Behala


"bpeltzer" wrote:

> Grouping the digits is just formatting... select the cell(s) then Format >
> Cells. Select the Number tab, and choose the Number category, set the
> Decimal places to 0 and check 'Use 1000 Separator'.
> To convert to text, check the Microsoft site and search for 'spellnumber:'
> http://support.microsoft.com/default...b;en-us;213360
> --Bruce
>
> "Hirak Chatterjee" wrote:
>
> > i want to convert the figure 123456 into (english) word
> > I also want to group the digit like 12,25,458
> > Both the answer should be in excel

I don't speak the Java, but you may want to invest in a book for VBA.

Debra Dalgleish has a list of books at her site:
http://www.contextures.com/xlbooks.html

John Walkenbach's is a nice one to start with. See if you can find them in your
local bookstore/internet site and you can choose what one you like best.

Hirak Chatterjee wrote:
>
> Dear Sir,
> I am very much obliged and grateful that you have created the program for me.
>
> I am very much interested to learn program of Visual Basic and Java.
>
> Would you kindly sendme something by which I can learn programming in visual
> basic and java.
>
> I have no basic idea about programming
>
> would you kindly response in my appeal.
>
> Thanks a lot and I will be obliged.
>
> Hirak Chatterjee
> India
> West Bengal
> Kolkata
> Behala
>
> "bpeltzer" wrote:
>
> > Grouping the digits is just formatting... select the cell(s) then Format >
> > Cells. Select the Number tab, and choose the Number category, set the
> > Decimal places to 0 and check 'Use 1000 Separator'.
> > To convert to text, check the Microsoft site and search for 'spellnumber:'
> > http://support.microsoft.com/default...b;en-us;213360
> > --Bruce
> >
> > "Hirak Chatterjee" wrote:
> >
> > > i want to convert the figure 123456 into (english) word
> > > I also want to group the digit like 12,25,458
> > > Both the answer should be in excel

--

Dave Peterson