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 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks