• How to deal with Microsoft Excel text overflow

    Text that is too long for a cell can be handled in several different ways. What is the difference between: (1) Not giving Excel any instructions about what to do with the text overflow (2) Letting Excel go with text overflow?

    Bethsmith1210 pointsBadges:
  • Excel 2007 – formula or macro to show value from one cell next to a given reference

    Hope someone can help. I am trying to work out a formula to place the value of a cell on a spreadsheet into a second sheet within the workbook using a reference in the column next to the cell with the value in it. EG - Sheet 1 has a cell with £500 in cell 3A The reference 1.01 is located in cell...

    PeteAtGlasshead5 pointsBadges:
  • How to recover an Excel file

    I did format my disk, but unfortunately, I also deleted an important excel file. I used getDataBack to recover that file, but when I get it back, I totally cannot read it, the data inside appear all like this...

    Devil5 pointsBadges:
  • Excel 2003 – Conditional Formatting Help

    Hi, I am working with a tracking schedule for my job, and I am trying to implement conditional formatting into it, but some of it it just not working for me. I am working with Microsoft Excel 2003 and I was wondering if you could help me with my problem. Column B = Start Date Column C = Due Date -...

    Kelz82740 pointsBadges:
  • Excel macro

    I would like the user to be able to hover the mouse over a picture which then would enlarge to some defined size and then return when the mouse is moved off of the object.

    JH3935 pointsBadges:
  • Compare and merge workbook in Excel Program

    Salam! sir I'm zia from Pakistan. I'm a permanent user of office program but I still dont know how to compare two workgroups? Thanks. Waiting for your answer.

  • How can I transfer more than 16384 records into Excel 2003

    Hi All, I am trying to transfer a table with more than 20,000 records from Access 2003 to Excel 2003, The code I'm using within VB goes like this: Private Sub Allstock_excel_Click() Dim filename As String filename = "D:\Automotive_Rapore\Archives\AllstockReport\Allstock_" & Format(Now,...

    Kentster5 pointsBadges:
  • Convert an Excel spreadsheet to a Access database.

    My questions: How do I convert data from an excel spreadsheet to a Access Database? How do I convert a access form to excel - Using the form as a front for data capturing? How do I link multiple users to a access database - making allowance for data to flow simultaneously into the database?

    Joshua55 pointsBadges:
  • Access database table linked to Excel file question

    Can multiple instances of the same access database be open when linked to same excel file?

    SeenFresh25 pointsBadges:
  • DTS: Export to Excel

    I'm exporting a simple table to Excel but my problem is that the table columns will change every month since the column names will list month names (ex. May2009). Can I use ActiveX to dynamically create the transformation source? Please help!

    Stan100125 pointsBadges:
  • Converting Data in Excel to PF on DB2/400

    Hi All, I have data in the excel where each column equal to the field of a physical file. I want load this data into the PF on AS/400. Could any one let me know the process on how to do it. Thanks in advance

    rajsubhyd105 pointsBadges:
  • Do you have a favorite construction estimating software tool?

    What is your favorite construction estimating software tool? Are you using Microsoft Excel? What about Sage? HeavyBid? HardDollar? Something else entirely? What makes the software so appealing to you -- was there one feature that made you shout, "I need that now!" or was it the whole package that...

    Beastwood1,105 pointsBadges:
  • Convert Number value in text string

    I am using Microsoft Excel 2007. I want automatic conversion of a number value into relative text string. It means if I have "687" into one cell, then it should be converted into "Six hundred and eighty seven" into next cell. Please guide me for this.

    Makkes5 pointsBadges:
  • SQL Export to Excel file column?

    I need to create a SSIS Package in which the data is export to Excel file the problem is the date and time column in sql there is one column and i need to separate it into two column can any body help e i thid? thank in advance

    Shamilh10 pointsBadges:
  • Excel question

    I have made some forms to use as proposals to sent to customers. I want to be able to send these as a document and not a spreadsheet. I need the formulas in the spreadsheet however to complete the proposal on my end. The pages print ok but I don't want to send an entire spreadsheet. Can this be...

    Alexworley5 pointsBadges:
  • How to paste data directly from Excel to PowerPoint graphic as data using Excel VBA

    I've been trying to search for ways to copy data from a spreadsheet onto the datasheet of a graph in an open spreadsheet. I am unfamiliar with VBA code, but got it to copy and paste to the correct slide, but only as text. I have been unable to select the actual existing graph and paste the data in....

    Charm20 pointsBadges:
  • Conditional formatting on Excel for Mac not showing

    I added a gradient fill to a column on my excel sheet but the color does not appear. It says the rule is applied but nothing is changed on the column or the table. What do I do to fix this?

    eperez35 pointsBadges:
  • How to convert a csv file into a xlsx one?

    Hi, I'm generating a csv file from an open hub in BW so I need to convert it into a xlsx one due to I need to upload it into the Microsoft SharePoint. Is there an abap function that does it? I know that there is one to convert an xls one into a csv. Thanks

    VPD5 pointsBadges:
  • How to recieve a excel file via AS2 running on iSeries

    I need to schedule to download reports from Walmat retail link. The reports are generated in excel format and downloaded using AS2 protocol. When I receive the file in iSeries it is not readable. I need to convert the excel format into data base file format. Any thoughts

    AS25 pointsBadges:
  • Excel to AS/400 PF

    I know this topic is widely discussed. But even after going through some of those discussion, I am not able to proceed. I have an Excel sheet which has one row header and one row of data, which includes both numeric as well as alpha data. I have opened it in notepad and but ',' separators after...

    RamvishakRamesh2,505 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following