General

Hyperlink text
I have a hyperlink, in a cell, say cell A1. This text, for example it may say 'blah', is then hyperlinked to a webpage, say www.hyperlink.com.....ie the text is not related to the name of the hyperlink. Is there a way i can then get the actual hyperlink, www.hyperlink.com, to appear in the next column? ... 26 Apr 2006 14:37

cell border colors in Excel
Cell border colors should be changeable without having to respecify the border lines for the cell. To reproduce the problem, open excel and apply a thick border to any cell. Now, click on the Format menu, then on "Cells..." then on Borders. Change the color to red and hit Apply. The cell color is unchanged. Ex... 24 Apr 2006 21:15

Text File
How can I make an Excel file create a text file ( only if the text file is not already created ) and keep adding details into that text file ( what is written across say 1 row thats made up of date, time, etc etc ) so I can look back in the text file as a kind of history file. This could be done every time the Excel ... 25 Apr 2006 17:43

Excel formula.
How do I keep a running total of columns and rows? For example I don't want to be stuck only with =SUM(A1:A4) which will only add the 4, but keep it open to infinity if needed. I have a small business and I am trying to make an accounting ledger of debits and credits. ... 15 Apr 2006 12:49

circumference formula
how do i get the circumference of a 4' diameter round tank ? ... 12 Apr 2006 16:16

TextBox Formatting
How do I format a UserForm TextBox to round decimal numbers to the nearest whole number. ie 1.0, 1.1, 1.2, 1.3, 1.4 should all round down to 1. 1.5, 1.6, 1.7, 1.8, 1.9 should all round up to 2. I can get it to display the Interger but this always rounds down. -- grahammal ---------------------------------------... 12 Apr 2006 12:02

GRAY SCREEN
When I try to open an Excel workbook that's in a folder, I get the gray Excel screen but no worksheet. If I open the program Excel and then open the workbook, the data is there. This is a new problem. I scanned for viruses but don't have any. How can I fix this? Please help me!! Desperate -- stella ... 11 Apr 2006 19:23

Personal.xls
Recently I followed the instructions at http://www.fontstuff.com/vba/vbatut07.htm to add the pop-up calendar to Excel. Since then when Excel opens, "Personal.xls" opens, and I thought that this would be "invisible", and that it would be a blank "Book 1" that would open when launching Excel. Is there any way o... 11 Apr 2006 12:37

forgotten password
i use a password to open excel file i forgot it can i open it? thnks ... 11 Apr 2006 10:00

If function
I have a new problem, how do I type the If formula for this one the formula is to calculate 401K contributions for employees. The formula should determine the number of years employed in column C is greater than or equal to 1, then the contributions is equal to the contribution percentage of 3% located in column ... 10 Apr 2006 21:00