How do I get functions added within EXCEL?
I am trying to use =HEX2DEC(cell) but keep getting the "NAME" error. I
believe it is because this is not listed in my available functions. How can I get these functions added to my copy of EXCEL? |
How do I get functions added within EXCEL?
On Fri, 26 Mar 2010 11:24:20 -0700, cgretired
wrote: I am trying to use =HEX2DEC(cell) but keep getting the "NAME" error. I believe it is because this is not listed in my available functions. How can I get these functions added to my copy of EXCEL? If your version of Excel is prior to 2007, you probably have not added the Analysis Tool Pak. If you look at HELP for the function, you will see a paragraph of what to do if you see a #NAME error. Also, HELP is a good place to look first, in general, for various Excel problems. --ron |
How do I get functions added within EXCEL?
Hi
This function show #NAME if the Analysys Toolpak is not installed. GotoToolsAdd-Ins check Analysys Toolpak. HTH John "cgretired" wrote in message ... I am trying to use =HEX2DEC(cell) but keep getting the "NAME" error. I believe it is because this is not listed in my available functions. How can I get these functions added to my copy of EXCEL? |
How do I get functions added within EXCEL?
Under Tools-Addins, make sure the Analysis ToolPak Addin is installed.
-- Best Regards, Luke M "cgretired" wrote in message ... I am trying to use =HEX2DEC(cell) but keep getting the "NAME" error. I believe it is because this is not listed in my available functions. How can I get these functions added to my copy of EXCEL? |
How do I get functions added within EXCEL?
It should be entered as
=HEX2DEC("cell") -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "cgretired" wrote: I am trying to use =HEX2DEC(cell) but keep getting the "NAME" error. I believe it is because this is not listed in my available functions. How can I get these functions added to my copy of EXCEL? |
All times are GMT +1. The time now is 01:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com