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

    Windows (ANSI) File Origin Import Default??

    I import a lot of text files into Excel. Most of the time the file origin is already set to Windows(ANSI)when I go through the import process, but not always. Is there a way to make Excel always default to Windows(ANSI)? I'm using Excel 2003 but will soon be converting to 2007. Thank you...
  2. JoannDavies

    Finding matching text in Excel columns

    I have 2 columns in Excel. Column A is a list of companies in a not so clean format: FordMCo MaybeIBM maybe not 4m of NH Smiths etc Column B is a list of companies nicely clean and neat: Ford IBM XYZ 4M etc Is there some code I can run to identify which companies in column A might match...
  3. JoannDavies

    Rounding down to nearest quarter

    Another rounding problem! I've searched the posts and can't quite make them work for what I need! I need to be able to round a number down (always down!) to the nearest quarter (.00 or .25 or .50 or .75). Can anyone help me? Thank you! Joann
  4. JoannDavies

    Excel User Form Number Formatting Problem

    I have a user form which has text boxes linked to cells in a spreadsheet. The cells in the spreadsheet are formatted just how I want the numbers to appear - no decimals and with a comma. The contents of the cells link just fine, I see the numbers I expect to see, but the formatting in the...
  5. JoannDavies

    Excel User Form Question

    I'm doing a User Form in Excel and I want to link one of the text boxes to data in a particular field in my spreadsheet. This works just fine when I type, for example, "b4" in the ControlSource Property. It links up just fine and shows the data from cell b4 in Sheet1.... However...

Part and Inventory Search

Back
Top