Search results for query: *

If you can assist I would be grateful: We have a database in access which is 5 cols wide and 800 rows deep. One col shows date, and is formatted in access as 'long date'. When we copy the database to an Excel sheet, (to facilitate manipulation as skills in Access are primitive), the date col...

I have recently invested in a new PC which has XP Home and was given Excel 2003 with the package. I am trying to install my "Personal.xls" from the old PC onto the new machine. but find I cannot access the XLStart folder to store the Personal file. I appreciate that the remedy may lie within XP...

Hi All, I have a spreadsheet which is a general file of expenses with one of the columns being 'Description'. In order to analyse the cumulative values I use an array formula which sums the values by description. {=SUM(($C$1:$C$80)*($D$1:$D$80=D88))} One of the descriptions is uniformly...

An unusual feature has started to appear on my Excel. Whenever I use the =MONTH function in a cell formatted for 'mmm' or 'mmmm' or anything other than 'number', the only result I can get is Jan or January, regardless of the date entered. The function does not produce the correct month...

I am exporting a file from a "SAGE" Accounts application in an Excel format and then pasting it into a more complex excel sheet. On each occasion that the data is exported some of the rows of exported data contain blanks (not zeros, BLANKS, EMPTY CELLS), the range of empty cells is...

I have been asked to provide a single cell function that will enable a calculation to show "the Present Value of a Single Fixed Investment which will yeild a given sum after 'x' years at 'y'percent interest" None of the usual 'functions' seems to achieve my goal. What would you...

I use Excel 2000. I would like to place a formula in a cell that records the date & time on the most recent occasion when the sheet/workbook is saved. I know the facility is available in Word, but is it possible to do this in Excel? Thankyou in advance Tonyjstone "Sometimes I sits and...

I have a spread sheet which calculates the sale prices of products. The sale prices are calculated on a basic cost plus margins plus tax, basis to make the PROPOSED SALES price. I would like to have the PROPOSED SALES price automatically rounded up to the ACTUAL SALES price so that all prices...

I have installed a "Combo Box" on a Spreadsheet to enable accurate selection of data from a list on another sheet. All is well EXCEPT for the size of the text in the Drop Down list. The 'origin list' is in Arial 12, and is easily readable, but in the Combo Box drop down list the text...

Whilst I am competent in Word and have been 'expert' in Excel for some time, I have NEVER used Access. I am advised that it is easy to learn the basics but I know a beginners course would speed my learning. Could any reader advise me where I might get an online course, or any other advice that...