Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Santee

    Excel - inserting lines

    Thanks so much for you help. It worked.
  2. Santee

    Excel - inserting lines

    How can I take rows of data and insert two lines between them. See example below: Looks like this: A B 1 234 at 2 342 be 3 125 ant 4 782 deal 5 572 field Needs to look like this: A B 1 234 at 2 3 4 342 be 5 6 7...
  3. Santee

    FORMS IN EXCEL XP

    Thanks swtrader. I wanted it in Access too(actually I already have most of it imported) but the person I am creating this for is dead set on it being in Excel even though I have stressed to her how much easier it would be in Access. Thanks again for taking time to respond.
  4. Santee

    FORMS IN EXCEL XP

    CAN SOMEONE HELP ME CREATE A FORM IN EXCEL XP. I HAVE A SPREADSHEET THAT HAS A TEAM NAME, DEPOSIT AMOUNT (10 DIFFERENT COLUMNS FOR INDIVIDUAL DEPOSITS), DEPOSIT DATE (10 COLUMNS TO MATCH UP WITH THE DEPOSITS), DEPOSITED TO (10 COLUMNS TO MATCH WITH DEPOSITS, DEPOSIT DATE),REG FEE (1 COLUMN)...
  5. Santee

    Printing Mulitple Charts on One Page

    Thanks KenWright that worked! :)
  6. Santee

    Printing Mulitple Charts on One Page

    The charts are in the same workbook just on different sheets. The data is on one worksheet. We created 4 charts from the data sheet. I tried what Anna2222 suggested but it still didn't work.
  7. Santee

    Printing Mulitple Charts on One Page

    Help. How do you do this in Excel XP.
  8. Santee

    Excel - Cells are dividing everything by 100

    Thanks Skip that worked! :)
  9. Santee

    Excel - Cells are dividing everything by 100

    Everytime I open Excel, every cell on every page(workbook) is dividing what ever number or character I put in there by 100. I have tried formatting it and that doesn't work. Any suggestions?
  10. Santee

    AmortizationTemplate

    Does Excel have this template like Lotus us too?
  11. Santee

    Column Width

    Is there a way to display more than 1,024 characters(ie...they want to print this document out and they want all the text to show...the largest cell has approx 2500 text characters).
  12. Santee

    Column Width

    Is there a max. number of characters you can enter into each cell (this is text in this particular cell).
  13. Santee

    Column Width

    Is there a max width the column can be in excel. I have a worksheet and it has a column width of 69.71 and will not open anymore unless I double click....the row height is 165.75. There is more text in the field but if you widen it then close the worksheet when you open it back up you can not...
  14. Santee

    Access export to Excel

    The export has only 12000 lines. We can get it to export 4000 but not the 12000 it just locks the system and will never complete. Any suggestions?
  15. Santee

    Access export to Excel

    Why would a text file export from diskette into Access ok but when you try to export it from Access to Excel the data will not all export. You can break it into sections and export but can't send it as one export. The field sizes are not large. How can you tell if the data on the disk is...
  16. Santee

    Query from two tables that only returns some of data

    Found the problem. Table was corrupted.
  17. Santee

    Query from two tables that only returns some of data

    Can anyone help me with this?
  18. Santee

    Query from two tables that only returns some of data

    Here is the SQL statement: SELECT DISTINCTROW [2001Telco].VendorName, [2001Telco].PN, [2001Telco].InvDate, [2001Telco].InputDate, [2001Telco].Description, [2001Telco].VendorAccountNumber, [Account Numbers].Project, [Account Numbers].Task, [Account Numbers].Resource, [Account Numbers].Provider...
  19. Santee

    Query from two tables that only returns some of data

    No the account number in the Vendor Info is the account number on the bill. These are for telecommunication bills that are received monthly. The account number in the Account number is for company charge back (the account number each area gives me to report to A/P). The reason for the joins...
  20. Santee

    Query from two tables that only returns some of data

    Vendor Name and Phone Number. I have checked to make sure that both have the same exact setting on each table and they do. (ie: format, data type...etc)

Part and Inventory Search

Back
Top