Ever since I upgraded my Excel fron XP to 2003, the HEX column on the TG master List has a #NAME? error.. not a big deal, since the TG Number is still id'ed.. is this a prob on my end or?
thanks
Updated Master list?
Okay, so this sounds like a cell formating problem. I am not sure what your spreadsheet looks like, but highlight the hex column and right-click and then click on Format Cells. Try Number, General, or Text and see if one of these brings it back to the way you had before you upgraded. One of these should work. You also might want to check your decimal spaces (for Number). No matter what, it should still treat the number the same way. Good luck.
strange I get the same too on Excel 2003.
From Microsoft Excel Help:
Correct a #NAME? error
Occurs when Microsoft Excel doesn't recognize text in a formula.
Click the cell that displays the error, click the button that appears , and then click Trace Error if it appears.
TOOL>Formula Auditing>Trace Error
Review the possible causes and solutions.
on Talkgroup 816
in the HEX Box it shows " #NAME? " then click on it then it shows " =DEC2HEX(A8,4) "
http://office.microsoft.com/en-us/excel ... 91033.aspx
From Microsoft Excel Help:
Correct a #NAME? error
Occurs when Microsoft Excel doesn't recognize text in a formula.
Click the cell that displays the error, click the button that appears , and then click Trace Error if it appears.
TOOL>Formula Auditing>Trace Error
Review the possible causes and solutions.
on Talkgroup 816
in the HEX Box it shows " #NAME? " then click on it then it shows " =DEC2HEX(A8,4) "
http://office.microsoft.com/en-us/excel ... 91033.aspx
Re: Updated Master list?
Your excel doesn't have the HEX formulas installed.scanner_gal wrote:Ever since I upgraded my Excel fron XP to 2003, the HEX column on the TG master List has a #NAME? error.. not a big deal, since the TG Number is still id'ed.. is this a prob on my end or?
thanks
go to the install program for office. Click Custom install. Dig thru the options and add all of the addons that you can. I think you can do it from within excel as well. Tools/Addons and add Solver Add On and Analysis Tool Pak (one of those I think)
You can also do it by doing custom install and select EVERYTHING by clicking on all of the items and tell it to install them.
-
- Posts: 10
- Joined: Sun May 28, 2006 10:02 am