General

whole numbers plus a percentage
If c4 is $1,500 and I want to add c5 4.845% to get sum of them in c6. ... 5 Jul 2008 14:34

Change hyperlink name to url
In excel I have a long list of hyperlinks to favorite places on the web. I want to print the url addresses. When I turn off the hyperlink only the "friendly name" is left. Is there a way to change the friendly name to the url address without manually typing or right clicking/edit hyperlink and then copying the ... 5 Jul 2008 14:34

Why isn't Wordwrap not wrapping the last sentence?
I formatted my cell to wordwrap, and then I pasted a relatively large piece of text. It did wordwrap over 20 lines, but then it stopped 10 words from the end. The only way I could get all the text to show up was to put in manual linefeeds. This doesn't happen all the time, just with a few cells. Has anyone ... 5 Jul 2008 16:36

Change Insertion Point
How do I send cursor to new insertion point that is not an ajacent cell? In completing a form I want the insertion point to go from B4 to A8 to D4 to C8 etc. ... 5 Jul 2008 12:31

How do I stop Excel from auto-inserting a date?
I am trying to type in 12-56 but Excel continues to format the cell into Dec-56. How do I stop this from happening? ... 5 Jul 2008 11:30

Merging Workbooks
I have created a workbook containing sales compensation data for 30 sales reps. I would like to create a commission statement (workbook) for each rep using excel. Ideally, as data is added to the master spreadsheet, each of the commission statements would automatically update. I know how to do this with prin... 5 Jul 2008 13:32

Change default from 2007 demo to 2003
I have vista installed on my computer, i installed microsoft 2003, the computer came with 2007 trial vs, everything keeps defaulting to 2007 when i open old files, i don't want 2007 to open up. I spend hours fighting any easy suggestions. ... 5 Jul 2008 16:36

Can't get my "'s Right - Never !!
I always BOMB when trying to UNDERSTAND How to place the " 's and the & 's when stringing together say line 3 below. Can someone assist? With Target .Offset(0, -1).Formula = "=row()-2" .Offset(0, 1).Formula = "=Vlookup(B"&target.row,Sheet2!$A$1:$B$7,2,False)" End With TIA, Jim ... 5 Jul 2008 11:30

Number Format
MS Office 2003 I have the following filter in a MS ACCESS query to pull buildings' square feet in size ranges in thousands from a range table. NewRange: Format([Min],"###,") & " " & Format([Max],"###,") I then move report into Excel to produce graph depicting number of stores in each ranch. However, Exc... 5 Jul 2008 11:30

add column into another column?
I`m aregentinian , so sorry for my limited english. I would like to know how to add a column into another column , for example , divide into two columns the column "C" , beggining in file number "4".- Thank you all , big hug.- ... 5 Jul 2008 10:28