Convert function not working Rao Ratan Singh 08.07.2006 07:19:01 Sir/Mam, I tried this function =CONVERT(2.5, "ft", "sec") but it is not working. it is giving #name? I m using office 2003. yours Rao Ratan Singh

Re: Convert function not working "JON JON" <conrado_capistranoREMOVE[ at ]msn.com> 08.07.2006 07:56:44 From help file: If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. How? 1.. On the Tools menu, click Add-Ins. 2.. In the Add-Ins available list, select the Analysis ToolPak box, and then click OK. 3.. If necessary, follow the instructions in the setup program. 4.. "Rao Ratan Singh" <RaoRatanSingh[ at ]discussions.microsoft.com> wrote in message news:795BBF72-2C66-4284-8ABF-9AACF3B37693[ at ]microsoft.com... [Quoted Text] > Sir/Mam, > I tried this function =CONVERT(2.5, "ft", "sec") but it is not working. it > is giving #name? > > I m using office 2003. > > yours > > Rao Ratan Singh begin 666 bluedrop.gif M1TE&.#EA#[ at ]`*`,03```=B0``_Z6E[KVZ\JFFXPPHC]#.][ at ]<`W]_A\00`Z[ at ]8` MXI65_]#0_QT5VR0=VXN+_YJ:_[>W_________P`````````````````````` M`````````````````````````"'Y! $``!,`+ `````.``H```4LX"2.9&F> IJ%D`;,L6).) R\-(48.4QA'\[ at ]8/A-%#\%(.4()$0I$0$PG,Z"0$`.P`` ` end

Re: Convert function not working paul 08.07.2006 08:21:01 if you get the #n/a error it means you are using incompatible units.The example in help is actually the one below,how can you convert feet to seconds? -- paul paul.shepherd[ at ]nospamparadise.net.nz remove nospam for email addy! "JON JON" wrote: [Quoted Text] > From help file: > > If this function is not available, and returns the #NAME? error, install and > load the Analysis ToolPak add-in. > How? > > 1.. On the Tools menu, click Add-Ins. > 2.. In the Add-Ins available list, select the Analysis ToolPak box, and > then click OK. > 3.. If necessary, follow the instructions in the setup program. > 4.. > "Rao Ratan Singh" <RaoRatanSingh[ at ]discussions.microsoft.com> wrote in message > news:795BBF72-2C66-4284-8ABF-9AACF3B37693[ at ]microsoft.com... > > Sir/Mam, > > I tried this function =CONVERT(2.5, "ft", "sec") but it is not working. it > > is giving #name? > > > > I m using office 2003. > > > > yours > > > > Rao Ratan Singh > > >

Re: Convert function not working "Bondi" <mbondorff[ at ]hotmail.com> 08.07.2006 08:32:52 Rao Ratan Singh wrote: [Quoted Text] > Sir/Mam, > I tried this function =CONVERT(2.5, "ft", "sec") but it is not working. it > is giving #name? > > I m using office 2003. > > yours > > Rao Ratan Singh Hi Rao, It might be that Excel is not recognising the function. This might be because you have not loaded the Analysis ToolPak Add-In. Try to go to Tools -> Add-Inns and here checkmark the Analysis ToolPak Option then press OK. I do have to agree with Paul though and say that i think that even with Analysis ToolPak loaded converting feet to seconds will be quiet a challange. Regards, Bondi