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!

Register Log in
  • Congratulations bkrike 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: *

  • Users: phospher
  • Content: Threads
  • Order by date
  1. phospher

    Comparing 2 differnet DB tables for Typo's

    Hi, I am trying to find a way to compare two DB tables for typos. I exported a customer table, edited a few fields, ie spelling of name or city, SSN etc. Then used the unmatched records query between the tables and nothing came up. I would appreciate any suggestions. Thanks, Phospher
  2. phospher

    Can't Import a MS Office Contact list into ShartPoint Contact List?

    Hi, I have been tasked to REKEY data FROM: a MS Outlook Contacts File: a print-out is a fellow workers partial cut & Paste list of Vendor contact list from his MS Outlook file. hand key it in our company TO: MS SharePoint Contact file. I know there is a way, but I'm running into a few snags...
  3. phospher

    excel conditional formula problem

    Hi, I am comparing order date column to the receive date column to calc number of days elapsed. But in testing this formula I get a FALSE instead of the number of days, for this particular line 17. Humph. column I column J Column K Order date Shipped Date Received Date 2/10/04...
  4. phospher

    Reformat date in Excel ...saved from csv file

    Hi again, The column dates from the csv file are formated like this Thu,27 Feb, 2003 I prefer to look at the date this way 03/13/04. Can this be reformated? there are over 10k records. Most greatful. Phospher
  5. phospher

    Reformating USD in Excel to number..(saved from csv file)

    Hi, I have a csv file which I have saved as a xls file. The column showing the dollars can not be reformatted: Format,Cells,Number. I have 10k records and don't want to manually edit every record. Delete the USD at the end of every cell. I tried to insert a new column and use the autosum to...

Part and Inventory Search

Back
Top