Search results for query: *

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

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.

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

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

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

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

How can one remove the 1st character of a string, so that the string displays without it? ex. change XHow are you? to How are you? Thanks

Hi all - when I use the FIND dialog box, the 'Look in' dropdown gives a choice of Formulas, Values, or Comments. However when I switch to 'REPLACE' those choices disappear and only 'Formulas' is left. Usually what we want to replace is Values however. I have searched settings, options, you name...

Hi All - I have tried to set and re-set my Home Page to www.google.com numerous times but whenever I open IE it opens to iGoogle.com instead. I have current virus software and it scans but detects nothing. How do I stop this from happening?? Thanks

Hi All, I have Office 2010 Outlook on my home machine and the inbox clears ALL mail by itself constantly. The Inbox folder is always empty. I can't see any pattern for this and have checked through every setting feature until I give up. I do not want my inbox emptied EVER, let alone every few...

Hi all - I had good luck yesterday from Skip where I used SUMIF to get the sum of values in an separate column where Col1 repeated Mon - Friday over and over down the page, but today i need to COUNT how many cells that have values in them (instead of adding them together) i,e, all the Tuesdays...

Hi all - maybe I am not going about this in the right way, but i have repeating groups of categories with values associated with them. I can use VLOOKUP to get the values associated with each category separately but i want to sum the numbers of all the VLOOKUPs. How can one do this? Thanks,,