Summary: P.S. It would be helpful if you could be more specific with your subject lines. If everyone who had an Excel question used a subject line as generic a...
Summary: I dont understand your formula. It appaear to be adding two values and subtracting a third. To find the difference between two dates it is just date1...
Summary: Hi all, My question for Excel: several cell with real values rounded up so that only integer value visible in the cell(digits beyond decimal point not...
Summary: thanks for the reply, do you have any step by step instructions or can you point me in the right direction for what i need to learn in order to do wha...
Summary: When merging data from an Excel spreadsheet into the Word Mail Merge letter, the "Annual Fee" column which is formatted as currency with 2 decimal poi...
Summary: My question is regarding Microsoft Excel XP. One day I decided to e-mail my Excel folder and since then every time I open the file the pop-up appears ...
Summary: Just a few questions about office XP 1. How do I insert an existing spreadsheet from Excel to PowerPoint instead of highlighting the spreadsheet and c...
Summary: Jennifer your not contributing anything valid. Here is my response to rhawks appropriate and correct response. "Yes for excel, do you by chance know ...
Summary: Hello, all - I've been lurking here for quite some time, and finally have a question that I'm not readily able to find an answer to! As such, I'd like...
Summary: Okay -haven't found anyone who can answer me yet... I have a spreadsheet I received with a column including time e.g. 21:35. I am trying to turn it i...
Summary: Providing the date is formatted as date and not a string all you need do is simply add 30. Dates are stored in Excel and nearly all Windows applicatio...
Summary: Bear in mind that dates and times are stored in Excel as floating point numbers. The part before the decimal point is the date and the part after is ...
Summary: Thanks DerbyDad03 Sorry for the newbie question -- I am not good at excel and using "fomula is" fuction. I tried your way and it applied to only one r...
Summary: i have a question about microsoft excel that has come up recently was wondering if anybody had any experice with this issue... heres how it goes File ...
Summary: Change the Excel field to contain only 2 numbers after the decimal point. "So won’t you give this man his wings What a shame To have to beg you to s...
Summary: Ok, THis might take a couple of steps, but this is what you need to do...Select all the text, and copy it to Word and paste it...then do a search repl...
Summary: 339,66 should actually be $339.66 29.912.79 should be $29,912.79 Either your raw data is invalid or the way you are importing is not correct. In the ...
Summary: We have a rather large Excel spreadsheet that we fill out ot run various reports at work. There 19 sheets per day + 1 for the week and all of them ar...
Summary: I am thinking that the only difference could be in the way each machine is interpreting/displaying the sales figures. For example: Sally: $100.45 Jane...
Summary: Not sure if I get your question or not but try inserting the following in column C: =IF(AND(A1="FOO",B1="BAR")1,0) Meaning If A1 =foo and B1 =bar then...
Summary: question.. i have a current inventory spreadsheet running. And on the "current on hand" page i have the totals for each size/style of apparel we have....
Summary: I have found all the above comments helpful, but wondered if anyone knew of a way to partially protect a cell. I might explain myself better by giving...