• We are trying to make database of membership

    We're looking to create a database for our membership (particularly searching for an Excel sheet).

    jagdishchandrajoshi5 pointsBadges:
  • 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.

    ITKE334,795 pointsBadges:
  • Joining two Excel spreadsheets

    I am looking for a way to join two spreadsheets in two different Excel files. They both contain a list of names and addresses. One is a master list that includes other fields, and the other is a list that only includes name and address and an ID column that was pared down by another office.  I...

    ITKE334,795 pointsBadges:
  • Import an attachment (which is embedded in Excel) to Lotus Notes RT field

    Hi, I want to import an attachment that is stored/embedded in an excel sheet. (d:\profile.xls)

    chandrasekarnagilla5 pointsBadges:
  • Microsoft Excel: Count number of distinct values in a range

    In my Microsoft Excel spreadsheet, I already have a large table with several filters. The only other thing I would like to add is a summary (underneath some columns) that contain the number of distinct values for that specific column. Is there a formula / function that would allow me to do that?

    ITKE334,795 pointsBadges:
  • Microsoft Excel is displaying ### for long text

    I've hit a crossroads. I have a long Microsoft Excel spreadsheet with long text in just one cell. Instead of line breaks, I keep getting these symbols "####." What can I do to get rid of these symbols?

    ITKE334,795 pointsBadges:
  • Convert spreadsheet into a flat file

    I need to convert a spreadsheet into a flatfile using the mid function. I only want to use a couple fields out of the spreadsheet, can someone help me?

    Kioh4650 pointsBadges:
  • Multiple users to one Excel document

    What is the easiest way to share a spreadsheet between multiple users in Excel? If I am setup in a work group environment and need multiple users to use the same spreadsheet, I know you can do the "select Share Workbook under the Tools menu" but how does that affect saving edits for each user if it...

    ConFlicker210 pointsBadges:
  • How to I create a Chart in Excel 2007 from Non Numerical Data?

    We have several projects going at work and my boss is tired of sorting through Spreadsheets and told me to graph everything. I need to figure out how to make a chart register how many of word/phrase A, B, C etc. there are in a column and stick that in a graph. If anyone could help I would really...

    Kuroia5 pointsBadges:
  • Importing from an Excel worksheet to Access form

    I have set up my database in access including the form that I want to import my information into, however when I try to import from an excel worksheet into access, it changes all my field names to field 1,2,3 etc. Then when I look at the form page all my sections have the word #NAME? in them. How...

    Horses5 pointsBadges:
  • Excel compact or compress utility?

    Microsoft Access has a repair and compact utility built into it. I'm looking for something similar for Microsoft Excel -- mostly to reduce the size of bloated spreadsheets. Any suggestions (other than manually copying the important data from the large spreadsheet to an empty and clean new...

    DKoch675 pointsBadges:
  • Change a field in a file

    I created a file using qry400, to hold the position of a field I used spaces '    ', now when I try to download to an Excel spreadsheet the info in that field comes out looking like HEX instead of what is in the field. Is there anyway to correct this? *** note - I must fix the file, I can not...

    hydr15 pointsBadges:
  • Scrolling

    In working with MS Excel 2003, there are darker scroll lines vertically & horizontally on the worksheet. When I try to scroll the page down below the line, only those cells scroll, not the whole sheet. How do I fix this?

    nccoolmom10 pointsBadges:
  • Opening Excel

    We use a shared workbook. As I understand how Excel is supposed to open, it should be at the same place where I last saved it. Instead, it opens at that location and then jumps to a weird place on another sheet. I cannot figure out why or how to make it go back to opening normally.

    tlsanders11,340 pointsBadges:
  • CVTPFXLS command options

    Hi people, I need some help with formatting Excel spreadsheets within the IFS. My program currently prepares a physical file on the iSeries and uses the CVTPFXLS command to create a Excel sheet. However, this sheet is pretty bland and I wish to add some formatting before the user gets it. The...

    tjgm88995 pointsBadges:
  • How do I remove rows from an Excel page

    I have an Excel spread sheet with a lot of data. However, between the rows with the data there are many rows that are empty. I want to remove the rows to make the data more compact looking. How do I remove them? There are too many pages for me to take the time to delete them one by one. Can anyone...

    Barrymore10 pointsBadges:
  • Excel 7

    I have a large spreadsheet with cell that contain  similar older catalog numbers. Want to update to the latest version of catalog number. Can I delete/ remove a character from the following Example:   23LB412  take out the "B" and keep the following: 23L412

    Coppertone5 pointsBadges:
  • Objects embedded in Excel

    I placed an object (PDF) in an Excel spreadsheet. When I go to minimize the row or filter the row/column's the objects do not move. How do I get it so it stays within that row?

    Chinavarepn5 pointsBadges:
  • Excel file

    Gents Could you please assist me in the below case: 1-I have 2 Excel sheet on my PC (Excel A is extracted on a daily basis from I Series by using data transfer while Excel B is the target one). 2- Excel B (target) has a special header and colors and contains 4 columns and 20 rows with zeros amount...

    Senior1systemanalyst260 pointsBadges:
  • Excel speadsheet

    How to delete a password from the workwook?

    leegustia5 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