I created a workbook with information to be used for merging to a letter. I created a heading colum to read "HOURS" and entered the numbers as 1:23. When I...

I'd like to restrict a user (me) from entering more than two digits after the decimal point in a cell. I have a checkbook spreadsheet and recently discovered...

I have been using the following code to pull information from a cell to name the sheet tab. Private Sub Worksheet_Change(ByVal Target As Range) If Not...

what is the proper way of entering a formula if you want to sum colum a if colum b is 03-01-05 but 04-01-05

Hi, I have the following formula set up on a sheet called 'Wow' =IF(Wow!A1="90 / 63 reducer", Wow!B1) What I would like to add (in plain speak) is if on Wow...

Does anyone know where it is in 2003 ?

Hi On a worksheet with premade formulas I used conditional format to mark out cells with formulas for rows where key kolumn cell (week number - the sring in...

Hi, In my columns when I type a number like 6.00, it would be automatically formated as 6 by Excel. How can I force it to be 6.00 ? Thx

Hi All, Whenever I search for something (CTRL+F) in excel it always defaults to the "Find entire cells only" setting. Is there any way I can change this...

I received a file that is saved as a .CSV format. How would I change this into the .XLS (normal Excel) format without having all the data jumbled up?

How do i enter negative times in Excel & how can they be 'fiddled with' to allow SUM functions etc... to work correctly? When I try to enter a negative time...

Hi Can you undo using macros? Thanks

I have just installed Microsoft Outlook 2003. I can no longer open Excel documents. The message I get is 'cannot find specified file'. When I open Excel it...

In excel i have locked certain cells in the spreadsheet as they were being deletd. However, users cannot insert a comment in the unlocked cells. I am using...

Cannot update instal repair or delete the above. Full system installed and all function ok except EXCEL which will not load under any circumstances Any ideas...

I am looking for a way to import a CSV or XLS file into my Lotus Notes Calendar. The content of the file is a baseball schedule for a MLB team. Any help would...

How do I print titles on every page of a spreadsheet in Excel?

I like to be able to compare 2 excel files to see how different they are.Is there such a thing?