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 just tried that again on the replicated spreadsheet and it worked. However, when I tried it on the user's worksheet who asked the question, it did not work.

I tried that one, too and it didn't work.

The one step I left out was that I first tried to open the hidden columns by double clicking on the line on the right side of the box that selects all. When I did that, the cross changed to an arrow pointing downward. I reset the column widths after selecting the whole worksheet and then tried...

Thanks much....it is driving me crazy.

I did use the square in the upper left corner to select all of the worksheet. If I do these same actions on a spreadsheet which I started in Excel everything works just like it should. The problem only happens when use the Analyze in Excel command in Access and then same the result as an Excel...

I did try selecting the entire worksheet and then doing the unhide but once it had been saved as an Excel worksheet it would not unhide the two columns that had been hidden.

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

Thank you for your help. Actually, after I wrote my question, I found the link that you provided in your response and was able to get tasks in at particular times. Is there some way to use Military time instead of regular? Also, when I put the task in and indicate that it starts at 12:00 pm...

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

I am not sure, but will find out. The only thing is that I had the same problems when trying to work with the document at home using Office 2000. Yesterday we discovered that the same things were happening when editing the document without the Track Changes feature enabled.

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?

=cell("FILENAME") will return the location as well as the file name.....ie D:\DATA\Excel\MYFILE\sheet1

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.

That worked.  Thank you very much.  It really improves the look of my report to not have the extraneous zeros all over it!  I am so glad that I found this website and this forum!

The false part is criteria for the same field as the date.  I am trying to put activity into columns by year. The field is a number field with 4 decimals.  When I used Null or " ", I could not change the field properties to standard number with 4...

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