1
  • Date format in Microsoft Excel 2002

    In my program I pass values from VB to Excel for reporting. When I pass 03-01-2009 (3rd Jan 2009), in excel it shows as 01-03-2009. I have set short date format to dd-mm-yyyy, in control panel, regional settings. Also in excel, I set cell format through VB as ... Exl.Range("A1").NumberFormat =...

    Mayuri155 pointsBadges:
  • Cell color coding

    I am using a spreadsheet designed by someone else and it has some formatting gin place that when a date is entered if it is within a certain period the cell goes green if not red and so on. I need to add some columns and apply the same formatting however for some reason I cant see the formula used...

    Mas85 pointsBadges:
  • Subtracting cells only if they have a value in Excel

    I want to subtract two cells in excel but only if both cells have a value. For instance, the formula I am using is thus: F2 is currently =E2-D2 but I only want this to be calculated when E2 has a value.

    ITKE413,615 pointsBadges:
  • invoice displays 0s when blank

    I created an invoice. I have used the cells A through G. Where A is the description of items and G is the Total sale. My problem is when A is blank G displays $0.00 for total. How can I get G to be blank when A is blank? Some other cells in between display 0 as well. I am currently using Microsoft...

    Abys5 pointsBadges:
  • Data entry and calculations in the same cell

    I have an excel template and would like to allow the user to input their date in one of two ranges and have the other range calculated automatically based on a formula to use in each cell This means that the formula needs to be outside the cells in the two ranges as they are both used for date...

    Askm5 pointsBadges:
  • Cell Formatting Protection

    How do I protect a cell (or series of cells) from being re-formatted, and yet allow the user to Sort and Copy the Data within the spreadsheet? When I LOCK the cell(s), then protect the Worksheet and contents of locked cell, I allow them to Select Locked Cells, Select Unlocked Cells, Delete Rows,...

    Cdixon20005 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following