General
in [Excel]
|
How can I type (R) & not get the registered symbol (r in a circle) edI recently upgraded from Office97 to Office 2003. In Excel 97 when I typed (R) that's what I got. Now, in Excel 2003, when I type (R) it automatically gets converted to the register symbol (the letter r in a cicrle). I have a spreadsheet on movies I've taped and always list the film's rating, i.e., (G), (PG),... 17 Feb 2005 20:48
Can I copy a combo box in Excel 2002 with a relative cell link? Would like to create multiple combo boxes by copying and pasting a cell containing a combo box but would like for the cell link for each combo box to be a relative cell reference so that the cell link is different for each combo box. Have tried changing the cell link to a relative reference before copying, but... 16 Feb 2005 21:34
Using fuzzy logic in excel Hello everyone, does anyone know of an application or vb code that can be used to search in two worksheets (like VLOOKUP) on similar matches using fuzzy logic? For example, if on one sheet I have I.B.M and the other IBM or James Smith on one and Jim Smith on the other, is there anyway of giving confidence... 16 Feb 2005 14:25
Footnotes in Excel? ExcelXP Is it possible to add a footnote to a cell that includes a formula? Thank you. ... 15 Feb 2005 21:10
Aligning decimals in Excel ... How can I align decimals other than using right justify in Excel 2000? I prefer the numbers to appear centered within the column, but with the decimals in alignment. The Center tool only gives me the former. All numbers have only one decimal place, but have various digits before the decimal. ... 15 Feb 2005 11:07
What does -- mean? I have been seeing "--" in formulae but cannot find an explanation of what it is or does. Example: =SUMPRODUCT(--(MONTH(B2:B13)=1), C2:C13) -- Ron P Sometimes you're the windshield:) Sometimes you're the bug:( ... 15 Feb 2005 09:35
How do I type the Spanish letter N? What keystrokes do I use to put a ~ over a letter n such as the Spanish word senor. ... 12 Feb 2005 23:20
i want to connect excel with sql server 2000 as database with macr i have a table Transcription_temp in sql server2000 i have to import data from excel daily. My excel file name is today.xls my excel headings are Userid Date TID PID Pname Dname Lines Wtype Template Clients my table header names are UserID TranscrioptionDate TranscriptionID PatientName... 14 Feb 2005 06:12
Excel's Dialog Box Hi every body, I'm having trubles with excel's dialog box, I can creat and execute the excel dialog box, but when information is request by the dialog box and, so on answered by user, I don't know how to directionate the writen information, I mean, cut the info writen in the dialog box and paste it in one of th... 12 Feb 2005 17:09
2005 Employee Vacation Calendar I am trying to create a 2005 Employee vacation calendar. Does anyone have a template for this? ... 12 Feb 2005 17:09 |