Search results for query: *

We are downloading general ledger information from Oracle 11.5.10 using an XML report and opening it in Excel. The value columns are formated as number in the XML report. Using Excel 2010 we are getting a few cells coming across as text that should be numeric. Using Excel 2003 the majority of...

I have lists of checks with values in the format XXX.XXX,XX which is the Brazilian (and other countries, I am sure)currency format. I need to convert this to XXX,XXX.XX or US currency format. Right now, Excel reads the number in the cell as text and I need it to be numeric. Any suggestions...

I have an Access 97 table that I wanted to analyze in Excel. I used the Analyze in Excel command found under Office Links in Access. Once the data was in Excel I inserted two columns to the left of the table date giving me columns A and B blank. I added dated to those columns and then did a...

I am very new to Project but cannot seem to figure out how to deal with military time and beginning and ending a task at a particular time during a day. Specifically, I have a project whicb works on a 24 hour a day basis. The first task begins at noon on a particular day and is budgeted to...

I am trying to write an Excel webquery which will link to a downloadable spreadsheet found on a web site. I have been able to bring in data when it is in a table format, but not if the URL shows it to be an excel file. An example of a site which I am trying to link to is as follows...

We are using Word 97. The document is a contract created in Word. When the document is opened in Word, no problem. After turning on the 'Track Changes" feature all is well for awhile. Then Word shuts down. If you try to open it again it tells you that it is in use. Any ideas...

I am using Outlook 97 along with Desktop to Go to sync my palm pilot.  When I do this there are some records in my contacts file in Outlook which will not open.  Any ideas as to why or how I fix it?

Can anyone tell me how to get gradiant color on a spreadsheet.  I can do it on a graph in excel, but can't figure out how to do it on a spreadsheet.  I am using Excel 97.  Maybe there is an add-on that would give me that capability.

I have a query which basically says<br><br>if end date &lt;= a date and &gt;= a date then subtract the start date from the end date and the start time from the end time to calculate the days and fractional days in that particular year. The false part of the statement needs to be no value in the...