Page 1 of 1
Updated Master list?
Posted: Sat Jan 13, 2007 5:07 pm
by scanner_gal
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
Posted: Sat Jan 13, 2007 9:36 pm
by El Pablo
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.
Posted: Sat Jan 13, 2007 11:07 pm
by Brian
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
Re: Updated Master list?
Posted: Sun Jan 14, 2007 1:30 am
by w6pix
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
Your excel doesn't have the HEX formulas installed.
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.
Posted: Sun Jan 14, 2007 9:33 am
by Brian
Cool
Easy Fix
It's working now by adding those two add-ins.
TKS
Posted: Sun Jan 14, 2007 12:49 pm
by PStuart
Another option, try openoffice.org . Its a free open source alternative to Microsoft office suite and has the same functionality and opens those office documents. Just FYI
Posted: Sun Jan 21, 2007 6:20 pm
by scanner_gal
thank you Mr. Wolfe! Your fix solved all
Posted: Sun Jan 21, 2007 7:48 pm
by w6pix
scanner_gal wrote:thank you Mr. Wolfe! Your fix solved all
Glad to hear it!