Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by EcoWill

  1. EcoWill

    Concatenation changes date format to a number Excel 2010

    That works. Thanks.
  2. EcoWill

    Concatenation changes date format to a number Excel 2010

    Hi all - I am concatenating three cells in Excel, (two text, and last one a date) and the concatenation works but is converting the date value into a number. How do we keep it as a date format? Thanks
  3. EcoWill

    Fill handle without breaking formatting

    Hey folks- of course Skip's 'paste formula' option is the way to go, and I knew that. Forgot. Duh. I don't get the option box that xlhelp suggested either, but will try that when I get home from my vacation or maybe sooner when I get to where I am going. (The Rockies). Thanks again!
  4. EcoWill

    Fill handle without breaking formatting

    Hi all - when you drag down the fill handle to auto-fill a formula down a column, it also drags out the formatting of the cells in those columns and you have to go back and re-do them which can be a pain. Is there a way to fill only NUMBERS and not cell formatting too? Thanks mucho.
  5. EcoWill

    Lock Excel 2010 workbook from edits

    Actually, no. It is in Review > Protect Sheet dialog box. Found it, and it works. If you go File > Save As there is no Tools button in this version.
  6. EcoWill

    Lock Excel 2010 workbook from edits

    Hi - I want to lock workbooks and password protect them, but it ain't working. This is Excel 2010. I click Review > Protect Workbook> then check Structure and Windows, then put in a password, and after i do that, anyone who wants can still go in there and make any changes that they feel like. It...
  7. EcoWill

    Conditional formatting question - Excel

    Ok thanks for that, but I do not see where I am choosing a color. If I want yellow, where is that in the formula? How about Green? Etc. And then there is the other issue - how then do i do a range to say, from 8-15 days, then yellow? Is it possible?
  8. EcoWill

    Conditional formatting question - Excel

    That is fine - the coworker who wants this answer wants red for next week (7 days or less) yellow for 8-14 days blue for 15-30 days. The colors will be in a separate cell than the date. Make sense? I hope
  9. EcoWill

    Conditional formatting question - Excel

    Hi T.T. - I know this is a conditional formatting plus date function question, but just not sure how to combine the two. I will use the =now() function as a reference. If a future date in a cell that is 'written in' (like September 15, 2011) is within 1 week i want the cell color to be red or...
  10. EcoWill

    Delete empty rows

    Ah yes - the helper column of numbers. Jeez. I have done that often in the past, but it has been a while. Totally forgot. Anyway - this was all good advice, and now I have a plan going forward. Thanks and hope you are having a nice holiday weekend.
  11. EcoWill

    Delete empty rows

    If it were any kind of science I would be better at it. I am a biochemist doing Excel!
  12. EcoWill

    Delete empty rows

    So then what I did was to just copy and paste just the values to another new worksheet and left the formatting behind. Internally it was remembering the blanks. Anyway, I have moved on with the workaround and I appreciate the help.
  13. EcoWill

    Delete empty rows

    I have no idea what you are talking about. When I selected the filter and checked blanks only, practically everything on the page disappeared. I am not an Excel expert. You are. Not me. And when this government job ends, I will retire and travel the country in my new expensive RV. I am only...
  14. EcoWill

    Delete empty rows

    You are right. Not only did I not follow your instructions, but I also did not understand them. When I turned the filter on, I unchecked []Blanks and the blank rows disappeared. So far so good. Now what am i supposed to right-click on? What blank rows? They have vanished.
  15. EcoWill

    Delete empty rows

    When i clear the filter, the blanks reappear!
See more

Part and Inventory Search

Back
Top