• How to convert text to date format in Microsoft Excel

    So I have a date (that's in text mode) that I need to convert to MM/DD/YYYY in Microsoft Excel. Can someone help me to do this: 22-FEB-18 10.54.53.000000000 AM Thank you so much!

    ITKE1,060,150 pointsBadges:
  • Keyboard shortcuts are not working in Excel worksheets

    Whenever I'm working on my Excel worksheets, I have several keyboard shortcuts that are mapped with their various macros. They've been working fine until recently. Now, a few of them are not working. It's happening on every spreadsheet too. I tried it on a different computer too and it's working...

    ITKE1,060,150 pointsBadges:
  • Update excel charts auto from as400 data

    I have a user request to create charts in excel using data held on the as400. I can do this in seperate steps but the user wants it as automatic as possible. At the moment : I run a query on the as400 to create data file I transfer using client access I open in excel & then copy data to graph...

    Gerrib150 pointsBadges:
  • Zero disappears in Microsoft Excel spreadsheet column

    My zero always disappears in Excel spreadsheet column. Please help.

    Pmallam5 pointsBadges:
  • Copying and Renaming Same File with a list of names using Visual Basic 6 code

    How do I copy and rename the same Word file from a list containing the names in an Excel database using VB6 Code?

    jlash1425 pointsBadges:
  • Limit to number of rows and columns in an Excel spreadsheet

    What's is the limits to the number of rows and columns that an Excel spreadsheet can have?

    Famous5 pointsBadges:
  • How to link Microsoft Excel file in SSMS 2014

    I'm using SSMS 2014 and I'm able to link an Excel file as a linked server. But here's my question: Now I want to link multiple Excel files. Can I link all of the files on a linked server or do I have to do them separately? Meaning one linked server for one Excel file.

    ITKE1,060,150 pointsBadges:
  • Cannot open Excel file from Microsoft Outlook email attachment

    I have Office 365 on my desktop. I just received an email in Outlook from a co-worker with an Excel file attached. But I can't preview the file at all. Here's the message I'm getting: This file cannot be previewed because there is no previewer installed for it. I tried just to open it with no luck....

    ITKE1,060,150 pointsBadges:
  • Export from SAP to Microsoft Excel

    I can't currently export from SAP to Excel. Can someone help?

    sharow5 pointsBadges:
  • Microsoft Excel keeps changing values in spreadsheet

    This is probably an easy question to answer but here I go. I'm a teacher and my students enter data into an Excel spreadsheet. But every single time, the value they put in changes. For example: 2.14 changes to 2 How can I format it in a way that it keeps the numbers behind the decimal point?

    ITKE1,060,150 pointsBadges:
  • Tooltips appearing all across Microsoft Excel spreadsheet

    So I'm trying to work on an Excel spreadsheet and I've run into an odd issue. These so called Excel 'tooltips' are popping up all across my screen. And popping up over each other. Is there anyway to stop this? I can't get any work done at all.

    ITKE1,060,150 pointsBadges:
  • Microsoft Excel: How do you group a list of companies/account numbers that are duplicated on several rows

    How do you group a list of companies/account numbers that are duplicated on several rows (separate purchases) to identify companies that purchased specific products within 2 code ranges (c50-c509, c18-c20.) and include ALL of the that companies purchase rows regardless of the product code in that...

    Csimon125 pointsBadges:
  • How to delete part of a Microsoft Excel cell

    Okay, so I have an interesting question. I was sent a Microsoft Excel spreadsheet and I need to delete parts of different cells. Meaning everything after this symbol '*' needs to be deleted (including the symbol). For example: JohnSmith*22101 This is how it should look after: JohnSmith It's too...

    ITKE1,060,150 pointsBadges:
  • Export batch files into Microsoft Excel spreadsheet

    I have roughly 20 or so batch files that I need to transfer to Microsoft Excel. MeaningĀ  - I want to transfer all of the contents of the files into Excel (which would make a list). What's the best way to do that? Thank you!

    ITKE1,060,150 pointsBadges:
  • Setup double-sided printing on Excel 2010 document

    Whenever I'm printing an Excel 2010 document (I used Ctrl + P), it's only printing on one side. I need to print on double sides. How can I set that up? This needs to be the default too.

    ITKE1,060,150 pointsBadges:
  • Stop recovery on autosaved files on Excel for Mac

    Whenever I open up Excel for Mac, I keep getting this message: Excel saved changes to the file before the application quit unexpectedly. And it forces me to go to the last saved version (even though my last session ended fine without any problems). So I've come to the conclusion that Excel thinks...

    ITKE1,060,150 pointsBadges:
  • Microsoft Excel keeps crashing when opening file

    A few hours ago, I saved a XLSM file (Microsoft Excel). When I just tried to open it, it's not working. I sent it to my co-worker and he was able to open it just fine. He sent it back to me and it's still crashing. We're still on Windows 7. Any reason why this would happen?

    ITKE1,060,150 pointsBadges:
  • Printing Microsoft Excel sheet in two different formats

    Hello, For my Microsoft Excel document, is there any way to print one sheet two different ways? Meaning print it on Landscape and also Portrait? I hope that makes sense. Thanks!

    ITKE1,060,150 pointsBadges:
  • Microsoft Excel won’t close without saving

    In Excel 2010, when I have a worksheet open and want to close it, often the sheet will not close unless I save changes. Sometimes it allows me to close without saving, and sometimes it does not.

    Contrain10 pointsBadges:
  • Command to set particular widths to Microsoft Excel columns

    I have assigned a command button that would assign a specific width to each column in a Microsoft Excel spreadsheet. But I sent it to a friend and when we tried to use the command button, the widths were all different. It's the same characters fonts too. What's wrong here?

    ITKE1,060,150 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