1
  • Field Propogation When Sending Spreadsheet by E-mail

    I have many users who frequently send spreadsheets by e-mail. For most of these users, when they click the "E-mail" button in the Standard toolbar of Excel, the information like To: and CC: automatically propogates. For a few users, who have identical configurations, this information does not...

    Schmidtw11,330 pointsBadges:
  • QMF results display as Excel sheet (line feed characters within data fields)

    When displaying QMF (V8.1) Query Results as an Excel spreadsheet, the Line control X'0A' characters within the data fields are causing: fields to split (multiple fields) where the where the LineControl characters occur and, the field and record to be continued [strong][em]on the following...

    Girwin505 pointsBadges:
  • Separating dates into year, month and day componrents

    I have an excel file of some 80,000+ records, one of whose columns - C- is in date - YYYY/MM/DD form. I want to split off the date into separate columns of years and months. I've managed to split off the years by using the expression LEFT (C2,4) where C is the label of the column containing the...

    Rogerc5 pointsBadges:
  • Excel 2002 Copy GetPivotDATA function

    I have a number of different items that I need to extract from a pivot table. Can I copy the GETPIVOTDATA function? it seems to get stuck and return only the value from the first cell

    Steve74745 pointsBadges:
  • Date format in Microsoft Excel 2002

    In my program I pass values from VB to Excel for reporting. When I pass 03-01-2009 (3rd Jan 2009), in excel it shows as 01-03-2009. I have set short date format to dd-mm-yyyy, in control panel, regional settings. Also in excel, I set cell format through VB as ... Exl.Range("A1").NumberFormat =...

    Mayuri155 pointsBadges:
  • Excel 2002

    I can open an excel doc, but can not add anything to it without inserting my 25 digit product key, which I do, but says it is the wrong key. It is a Publisher 2002 version, operating on a Windows Vista any suggestions?

    Sprinkleclan55 pointsBadges:
  • Excel “import external data” Newlines in text query

    I am using Excell 2002 "import external data" - With tab delimited fields within record - One text field has newlines within it - The newline is treated as end of record Problem recently arrose possibly coinciding with update to IE version 7 Geof Lewis

    Gowen5 pointsBadges:
1

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