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 Chriss Miller 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. weetnie

    Epicor eBachOffice Login error

    Type in Username and password then click on properties and Comfirm the contoll database and Company is ok the click ok This happens with us when we switch companies
  2. weetnie

    Excel if statements?!?!

    Try typing 100
  3. weetnie

    Excel if statements?!?!

    Hi There Try =IF(A1=&quot;&quot;,&quot;&quot;,IF(A1<100,A1+10+(A1*0.15),IF(A1<200,A1+20+(A1*0.23),IF(A1<300,A1+30+(A1*0.35))))) First if brings back blank for blank (Use 0 for calculation field) then you can get 6 more IF functions in (Can do an extra 7 if you use a another reference field.
  4. weetnie

    open excel file through explore

    goto> my computer>Tools>Folder Options >file Type search for the .xls extention and double check if Excel is selected as program file, (Check under the advance tab that the excel.exe location is correct)
  5. weetnie

    Excel: Date function doesn't show correct date

    Have you got your cell format on general?
  6. weetnie

    send to

    Another good trick is to add a shortcut to your notepad in the sent to folder. So you open a file with Notepad, (Instead of going through the 'open with'option
  7. weetnie

    How to set cells to take a max of 23 chars ?

    You could use a left function in the column next to the field=left('cell',23). or set that procedure up as a macro
  8. weetnie

    Excel Lookup with Two Criteria

    Hi, You could try combining the two columns eg vlookup((A1&b1),'sheet2C:D,2,false) Where C:D is a combined lookup table If this does not work could you give an example of the lookup result?
  9. weetnie

    import a word form to excel

    You could save the Word file as an text file and import it in Excel (through File> Open> [files of type] '*.txt'
  10. weetnie

    How do code a Command Button in Excel to unprotect a worksheet?

    Why not try to Record it as a macro, Compare that code to yours,
  11. weetnie

    Decimal places

    Use the formula round(cell,&quot;# of Digits&quot;) Otherwise format cells tools options Calculation tab Precesion as displayd note this is a permanent solution, no roll back
  12. weetnie

    Keymaps?

    AR Maintenance Set Up Automatic Numbering
  13. weetnie

    Excel sort and delete duplicates

    Have you tried Running a combination of a Pivot Table and Vlookup?
  14. weetnie

    Excel Fill

    Try Copy the cell and pres <shif><CTRL><down Arrow> then paste (<CTRL> <V>) then <CTRL> <Down Arrow>, to go to the next emptie field
  15. weetnie

    Can't Open .txt files in Excel

    Have you checked the properties from the text file, is the read only file ticked) if so untick read only and try again
  16. weetnie

    Filtered Data - Row Numbers

    Highlight Collumn, select count functions from bottom right tool menu.
  17. weetnie

    Keymaps?

    Have you tried to add the 'B' in the 'Automatic Numbering' option?

Part and Inventory Search

Back
Top