Re: $$Excel-Macros$$ Numer To Text

Hello Ankit , There are also add-ins which will be able to install in 2003.Download Ultimate add-in. There are two versions of That New one will be in 2007 but the old one can be installed in old versions also.For installing add-ins in old versions of Excel the process is different.The add-ins opt

Re: $$Excel-Macros$$ Numer To Text

Dear Ankit, Here is a code that might help you. It is didvided into prts depending upon your requirement copy and pate the required part in Visual basic. '' Main Function *' Function SpellNumbers(ByVal MyNumber) Dim Rupees, Paise, Temp Dim DecimalPlace, Count ReD

Re: $$Excel-Macros$$ Numer To Text

Thank you for your help But Sir I am using 2003 excel & i m working on networking PC thus I think the add-in did not install properly. On Tue, Oct 5, 2010 at 12:35 PM, P.VIJAYKUMAR wrote: > Dear Ankit, > > To use the add-in select the number you want to convert into text.then go > to the ad

Re: $$Excel-Macros$$ Numer To Text

Dear Ankit, To use the add-in select the number you want to convert into text.then go to the add-ins in the Menu bar and select the text to numbers button. Automaticaaly the number you selected turns into text. But, you dont't have the original number.If you want to have the number and also the co

Re: $$Excel-Macros$$ Numer To Text

Dear Ankit , There is also an add-in called Ultimate add-in which contains a lot of other features like finding and removing duplicates, transposing cell contents between two cells etc, along with text to numbers conversion feature. But,unfortunately some features of them are not working.But it

Re: $$Excel-Macros$$ Numer To Text

Thank you sir for deteil knowledge but again same problem *how we can use add-in? plz tell me * ** Thnanks & Regards Ankit On Tue, Oct 5, 2010 at 8:30 AM, P.VIJAYKUMAR wrote: > Dear Ankit, > > There is no Direct formula to convert numbers into text.But there are some > add-ins available in th

Re: $$Excel-Macros$$ Numer To Text

Dear Vijay Very Good explain by you Thanks On 10/5/10, P.VIJAYKUMAR wrote: > > Dear Ankit, > > > There is no Direct formula to convert numbers into text.But there are some > add-ins available in the websites. just google for text to numbers converter > in excel add-in. > Once you download th

Re: $$Excel-Macros$$ Numer To Text

Dear Ankit, There is no Direct formula to convert numbers into text.But there are some add-ins available in the websites. just google for text to numbers converter in excel add-in. Once you download the add-in to install the add-in to excel go to the excel ribbon Button, the from there open excel

Re: $$Excel-Macros$$ Numer To Text

But sir how it add in to excel. Thanks & Regards On Mon, Oct 4, 2010 at 1:35 PM, Mahesh wrote: > Hi ankit, > > Attached herewith is the add in. > hope this will solve the issue. > > On Mon, Oct 4, 2010 at 12:04 PM, Ankit Agrawal < > ankit.agrawal...@gmail.com> wrote: > >> Thank you sir but it

Re: $$Excel-Macros$$ Numer To Text

I have add it But How to use it. thanks & regards, ankit On Mon, Oct 4, 2010 at 4:40 PM, Ankit Agrawal wrote: > But sir how it add in to excel. > > Thanks & Regards > > On Mon, Oct 4, 2010 at 1:35 PM, Mahesh wrote: > >> Hi ankit, >> >> Attached herewith is the add in. >> hope this will solve

Re: $$Excel-Macros$$ Numer To Text

Thank you sir but it happen in only one file if we want to def ult it means in every excel sheet it implement automatically. Thanks & regards Ankit On Mon, Oct 4, 2010 at 10:18 AM, C.G.Kumar wrote: > > See http://support.microsoft.com/kb/213360 > > > Hope

Re: $$Excel-Macros$$ Numer To Text

See http://support.microsoft.com/kb/213360 Hope it serve the purpose. On Mon, Oct 4, 2010 at 9:22 AM, Ankit Agrawal wrote: > Hello Sir, > > Plz tell me any formula that convert number to text like > > 1500/- > one thousand five hundered only > > Thanks &

$$Excel-Macros$$ Numer To Text

Hello Sir, Plz tell me any formula that convert number to text like 1500/- one thousand five hundered only Thanks & Regards, Ankit -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks