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 gkittelson 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. 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

    I formated the cell(s) in the column as date and choose 03/14/03 style. I never format cells as general. My formated dates show 01/01/04 all 6 numbers filled in. Not 5. Sorry if I'm misunderstanding this. I'm still open for suggestions. Most Greatful, Phos
  5. phospher

    Reformat date in Excel ...saved from csv file

    I've changed my dates from Thu,27 Feb, 2003 to 27 02, 2003 by using find and replace tool. Now would it be easier to reformat this vs the origional wordy Thu,27 Feb, 2003? Phos
  6. phospher

    Reformat date in Excel ...saved from csv file

    This did not work. I have tried it in a new column on either side of the date. Ive tried the Insert function Fx. I am stumphed. Phos
  7. phospher

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

    Thank-You Blue dragon2. It worked like a charm. My purchasing group is most greatful as well. Phos
  8. 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
  9. 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