• Zero keeps disappearing in my Excel spreadsheet column

    So I'm adding some of my personal information into an Excel 2007 workbook and I've noticed that when I put in a number count that starts with zero, it automatically disappears. Here's an example: 012345678 changes to 12345678 What do I have to do keep the zero as entered and not disappear.

    ITKE434,310 pointsBadges:
  • Find interest rate on loan using VLOOKUP in Excel

    I need to find the interest rate on a loan using vlookup in excel, selling price $250,000 on a 20 year loan.

    1101jones20 pointsBadges:
  • Auto populating cells in Excel based on time

    So I am given times of the day and I need to match the shift with the time so I was wondering if there was a macro that would make this easy. For example, between 07:00 and 15:00 is shift 1 and 15:00 to 23:00 is shift two and the other period is shift 3. I'm sure that there is a loop for this but...

    zbehnen15 pointsBadges:
  • Loading image into MySQL database from Excel file

    I have an excel file that contains an image in the first col. When I save it to an csv format, the excel program creates two images ( 1 small, 1 large) for each line in the excel file. How do I load both the file data and the large image into my mysql database?

    Wlm49hv5 pointsBadges:
  • How to open CDB files

    I have a large CDB file of car part numbers. I need to open it and convert it to Excel.

    leseding5 pointsBadges:
  • Linking Data in sequential Excel spreadsheets without having to open all of them

    How can I link data in sequential Excel spreadsheets without having to open all of them?

    rcollie5 pointsBadges:
  • Best way to create a flat file

    Is there a format I can buy or can I convert an Excel spreadsheet into a flat text file?

    CJSDOYLE5 pointsBadges:
  • Excel pivot chart drill down

    Hello, The aim is to click a slice on a pie pivot chart, that will show another pie pivot chart, NOT data. Is this possible with Excel, again I want to click a slice on a pie pivot chart, that then leads to another pie pivot chart. Preferably go 3 or 4 levels down. Thank you.

    Michael9995 pointsBadges:
  • Problem with AS/400 data transfer to Excel

    I have been downloading AS400 query files to Excel spreadsheets for many years using the Data Transfer utility in Client Access. There has never been any problem. Now suddenly all of the output data has started transferring to Excel as long hexadecimal strings and is unusable. I asked the IT folks...

    JDK55 pointsBadges:
  • Connect Oracle database from Microsoft Excel application

    Is it possible for me to connect to an Oracle database from a Microsoft Excel application without a DNS? I tried to do it already but it keeps giving me an error saying: The driver was not found. What should I do here? What driver am I supposed to use?

    ITKE434,310 pointsBadges:
  • Export SAP reports to Excel

    I have an issue with SAP Reports. I am usually exporting mass data from the system, and my company doesn't allow to have a external system to help for that for security issues. Is there any way I may do to export these reports faster to Excel.

    KarimHosny5 pointsBadges:
  • Excel cannot open the file ‘file.xlsx’ because the file format

    Every now and then, when I try opening an Excel file, I get a message saying that "Excel cannot open the file 'file.xlsx' because the file format or the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

    weinmagaul5 pointsBadges:
  • How to IBM Genius iSeries application connect to Excel VBA

    How to IBM iSeries Access for Windows connect to Excel VBA or can enter data using VBA code?

    Vijay19915 pointsBadges:
  • Best way to run a program in Microsoft Excel or Access

    Good day, I would like to find out what is the best way to run a 'program' in Microsoft Excel or Access (at the moment, I am used to Excel only but I'm willing to learn about Access if that's what it takes) that will allow me to type in one or two letters and it produces a word in the particular...

    asphaltanimal5 pointsBadges:
  • Restrict users from editing in Excel header

    In my Excel worksheet, I currently have a fixed number of columns. All of these columns has a header name. Can I restrict different users from entering anything in those header cells? Thanks so much.

    ITKE434,310 pointsBadges:
  • T-code S_ALR_87013611

    If I look the SAP id of my office mate, the code S_ALR_87013611 was in the excel format. How can I do this in my SAP ID. Thanks!

    eiseljaneenriquez5 pointsBadges:
  • Excel Spreadsheet corrupted (.xls)

    Hello all and thank you in advance for your help. One of my customers has an Excel 2003 document that appears to be corrupt. When I open the excel document I get the following error: "The file you are trying to open, 'database.xls' is in a different format than specified by the file extension....

    Codhard45 pointsBadges:
  • Copy Excel PowerPivot data into a table

    We have a large amount of data in PowerPivot (Microsoft Excel) that's been modified and now I'm trying to put it into my workbook as a regular table. We don't want it as a PivotTable - it's because I have to do some VLOOKUPs for another sheet. How can I do this?

    ITKE434,310 pointsBadges:
  • Convert Microsoft Excel calendar week into date

    I apologize in advance if this doesn't make sense but, in Microsoft Excel, we have a week number and the associated year. In our Excel sheet, can we calculate the date of the Friday of the week in a cell? Is there a formula? Thank you very much.

    ITKE434,310 pointsBadges:
  • Filter Microsoft Excel table

    In Microsoft Excel, I have a large table that I need help filtering with. Furthermore, several of my users asked me to get a total row at the end of it. Here's my concern: Won't the last row be filtered as a normal row? Basically, can I sort out that last row so it's not filtered? Thanks!

    ITKE434,310 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following