I am trying to add multiple numbers within a cell but show the work example A 40+20 This column I need to add the 2 in Column A together to show the sum or total of them in Column B – example Column 1 ...

One of our users came to me to say that consistently, for the last three or so months, several of our password protected Word docs and Excel workbooks have required her to put in the password twice before they’ll open. ...

PROBLEM: You can Cut or Copy just fine, from a website or from your Word document, but when you try to Paste, the word “Paste” is greyed out and unusable; you just can’t Paste! SOLUTION (Old Word): Click View, Toolbars, Clipboard– ...

I am looking to make an IF statement for the following: In cell J1 there is a date in it and I want I1 to read “Calibration Due” if the date in column J is less than or equal to 45 ...

I have a series of data points that I am trying to fit a line to. The problem is I have a large amount of outliers randomly scattered within the data that is also on the excel graph. All I ...

I don’t remember how to format my excel document to keep it from splitting up merged cells between pages when printing

I have an Excel VBA form that I use for data entry and data retrieval. (People don’t need to know how to use Excel.) One field in the form compares the current date to a previous date stored in a ...

Hi Can I get Absolute Cell reference with INDIRECT function? Presently I have a 2 worksheets named “April 2011” and “Summary”. I want to access a value of cell in “April 2011” worksheet in “Summary” worksheet. So I used the ...

Hi there, I’ve built an app in VBA (Excel 2007) which is a portable application. It can work in a number of locations and will occasionally need to transfer files to a cloud server. I can test to see if a ...

Money97. Would anyone know where I could get help files or a book for this program.My help files have been corrupted or have been deleted and I can’t find the origional disk and as microsoft dosen’t support this program any ...