General

Column Text
I have a column of links to various web pages. How would I change the whole column to show the words 'Click here" instead of showing the link for each cell? Is there a formula? Thanks in advance!! ... 6 Jul 2008 12:59

Weighted averaging of dates
Gentle people, I have come up against a problem doing some Excel time/cash-flow calculations and could really use some help from the "brain trust" here. It's a bit complicated, but let me try to break it down. First I'll summarize the goal and the problem: The goal is to take data on stock purchases and... 6 Jul 2008 23:12

rearranging formula suggestion
Hello for help, With the best of my memory, i forgot what i learned before. Please suggest how i can prepare a sorted column of infos based on below (e.g) table In sheet 1 col A col B col C col D col E row 1 NAME 100 105 215 280 row 2 ABC A1 A2 row 3 CDE C1 C2 row 4 DEF X1 X3 row 5 FGH F1 F2 ... 7 Jul 2008 10:26

How to display decimal number only?
Does anyone have any suggestions on how to display decimal number only? For example, 10.28 in cell A1, and I would like to show 0.28 in cell B1. Does anyone have any suggestions? Thanks in advance for any suggestions Eric ... 6 Jul 2008 05:50

Print Worksheet Poster Size
I want to print a worksheet as a poster 24 x 36. My printer will do a 4 page by 4 page poster, but I have to trim and tape the pages. How do I setup printing for poster size? Is it possible for a commercial printer to print an Excel worksheet? If so, could you recommend a printer? ... 6 Jul 2008 10:56

combining documents help needed
hi every one i need help im trying to work how to combine a excel 2007 document with a word 2007 document togeather so i only got the one can some one help please. -- freeway29 ... 6 Jul 2008 02:47

how do I write a macro to show the find dialog box in excel 2003
... 6 Jul 2008 08:54

how do I extract only certain data from a cell?
Office 2003, Win XP Pro. I am presented with a worksheet containing dozens of cells in which is contained data of different lengths. eg Zippohat 52131123Sa011880702 Baker 18164 Renatsainv17247 15592 Inv Each contains an invoice number, as follows: 18807 18164 17247 15592 These invoice numbers range between... 6 Jul 2008 16:03

need help
the following error have been occured: How to read and edit corrupted xls file? ... 6 Jul 2008 08:54

How to create a back-up for excel file.
Now that I have "Auto Back Up" turned on for my Excel 2002 file, I want to choose the location where the back up copy is to be saved. Currently, I'm working with a file on a floppy disk but I want the back up copy to be save on a hard drive. Does anyone know how to do this? "David Biddulph" wrote: You h... 6 Jul 2008 08:54