RE: $$Excel-Macros$$ Convert to number

2012-09-17 Thread Rajan_Verma
=LEFT(A2,LEN(A2)-1)*1 Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Robinson Boreh Sent: 17 September 2012 12:42 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Convert to number

Re: $$Excel-Macros$$ Convert to number

2012-09-17 Thread RAJA SEKAR
Hi, if all values are in same column use convert text to column wizard.. On 17 September 2012 13:12, NOORAIN ANSARI wrote: > Dear Raobinson, > > Please try.. > > *=--SUBSTITUTE(A2,CHAR(10),"")* > > -- > With Regards, > Noorain Ansari > http:// > noorainansari.c

Re: $$Excel-Macros$$ Convert to number

2012-09-17 Thread NOORAIN ANSARI
Dear Raobinson, Please try.. *=--SUBSTITUTE(A2,CHAR(10),"")* -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclinic.com On Mo

Re: $$Excel-Macros$$ Convert to number

2012-09-17 Thread Karan Singh
Hi Robin, Rather than using my earlier solutions use below one : =trim() > copy > paste as value > Convert to Number. Regards Karan Singh On Mon, Sep 17, 2012 at 12:52 PM, Deba Ranjan wrote: > Hi Robin, > > can use this for cleaning the number:- > > =IFERROR(CLEAN(TRIM(A2)),"")

Re: $$Excel-Macros$$ Convert to number

2012-09-17 Thread Deba Ranjan
Hi Robin, can use this for cleaning the number:- =IFERROR(CLEAN(TRIM(A2)),"") Thanks & Regards, *Deba Ranjan P* On Mon, Sep 17, 2012 at 12:47 PM, Karan Singh wrote: > Hi Robinson, > > Use =trim(your number) > > Regards > Karan Singh > > > > > On Mon, Sep 17, 2012 at 12:41

Re: $$Excel-Macros$$ Convert to number

2012-09-17 Thread Karan Singh
Hi Robinson, Use =trim(your number) Regards Karan Singh On Mon, Sep 17, 2012 at 12:41 PM, Robinson Boreh wrote: > Dear members, > I have an excel sheet with numbers, but they contain a non numeral > character at the end and i can not therefore sort nor do any mathematical > function on the

$$Excel-Macros$$ Convert to number

2012-09-17 Thread Robinson Boreh
Dear members, I have an excel sheet with numbers, but they contain a non numeral character at the end and i can not therefore sort nor do any mathematical function on the . Please assist with a formula of getting rid of the non-number characters so i can sort and add. Regards, Boreh -- Join offi