Search:

Type: Posts; User: gholt; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Flagging incorrect months with a rolling date

    I think I found the problem. I change the < to be <=. That fixed it, I appreciate help in pointing me in the right direction.
  2. Re: Flagging incorrect months with a rolling date

    Well, I thought that having the 1st two conditions clarify that it was in the right paramater, that it would not have a highlight and if they were not met, 3 & 4 would highlight them. Is that not...
  3. Flagging incorrect months with a rolling date

    I have been trying to set up a flag for an incorrect input date and I thought I had it. Basically, there is a window when our Journal entries need to be input to close the month. That is from about...
  4. Replies
    5
    Views
    499

    Re: Add back missing zeros to customer #

    Thanks. I love that there are so many ways in excel to solve a problem. I think I took the long way. I'll use the shorter solutions.
  5. Replies
    5
    Views
    499

    Re: Add back missing zeros to customer #

    Got it figured out.

    1) Len(Customer # cell) Returns # of Digits
    2) Copy len to value
    3) Add a colum with six 0 "000000"
    4) Concatenate (left("00000",6-(len formula), then cust #)
  6. Replies
    5
    Views
    499

    Add back missing zeros to customer #

    I have a 8,000 row file that has a customer number for each row; however, on the customer # where there is less than 6 digits, the zeros are missing. Is there a simple formula that would add the...
  7. Re: Formatting Dates for Error for Journal Entry

    Thanks. I was able to use that in the conditional format to decide whether or not to highlight the field.

    Thanks again Gerald.
  8. Re: Formatting Dates for Error for Journal Entry

    I took care of the < 20 through a conditional format. I'll try fixing the formula for the 30 day fix and see what that does.
  9. Formatting Dates for Error for Journal Entry

    We create our journal entries on excel files. and to ensure that we are not picking up the previous' month or have an invalid date in the date field we wanted to create a visual for the user to see...
  10. Replies
    0
    Views
    285

    Excel 2007 Running Slow w/40 files

    I have about 39 files (spreadsheets) that are linked to two master spreadsheets. For some reason when I open these in Excel 2007, it runs very slow. I have updated all the files to the 2007 version...
  11. Replies
    7
    Views
    24,636

    Re: Easy-XL 30-Day Trial Available

    What are the licensing requirements. For example, we may have up to 200+ people who have excel on their computer, would it be per computer or per site etc.?
  12. Replies
    1
    Views
    241

    Re: Copying down cells to get across rows.

    Anyone?
  13. Replies
    1
    Views
    241

    Copying down cells to get across rows.

    <TABLE style="WIDTH: 327pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=436><COLGROUP><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2779" width=76><COL...
  14. Replies
    4
    Views
    566

    Re: Frustrating Issue!!!

    You could also do text to columns, under the data menu. Just follow it through and make it a general data.
  15. Replies
    4
    Views
    441

    Re: Simple Copy/Paste question

    Shrink down the excel window, if you can and make is smaller, like so:

    Oh, I gues I can't pase an example.

    You could also do a print as a pdf file with just the area you need and set in the...
  16. Re: Increase shade of hightlighted cells for Excel 2007

    I found out that it is a known bug. The only solution is to adjust the contrast and the windows color themes. Hopefully, this will be addressed in their service patches. I'm not holding my breath,...
  17. Increase shade of hightlighted cells for Excel 2007

    I couldn't find anything about this during a search, so I thought I would ask. If it has already been answered, could you point me in the right direction.

    We now have the 2007 excel here and I...
Results 1 to 17 of 17