Search results for query: *

That works. Thanks.

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

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!

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.

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.

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...

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?

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

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...

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.

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

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.

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...

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.

When i clear the filter, the blanks reappear!

Of course. Perfect. Thanks.

Hi T.T. - Each month receive at my desk a series of new spreadsheets, each with thousands of rows of data that I have to reorganize to create pivot tables. I do not have the authority to change the formatting at their source (they come from government agencies and that is HOW THEY DO IT) The...

Alright then. How would one go about expressing the the source data as dynamic? More to the point, can it be done without writing code and creating a macro? Because nobody in this company knows how to write VBA code (nor are we interested in learning!) Thanks.

Nice to hear from you again Skip. I found what needed right there in Options>Data>refresh. Bingo. So even though I did NOT have the source data in an actual 'table', the 'refresh' function worked just fine, so now I know for next time. Always happy to do business with Tek Tips experts, and I am...

Hi T.T. I have been frustrated with the apparent property of pivot tables (Excel 2010) that the data within them does not change when the numbers in the table they are taken from changes. It's as if the data in the pivot tables are no longer connected to the data they are created from. Is there...