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 Rhinorhino 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: scat
  • Order by date
  1. scat

    Serve up another domains webpages

    Is it possible to serve up another domain's web pages from my server. The 3rd party domain will only allow my webserver ip to access certain pages. I want to put links on my server that link to these pages. The problem is that I need my server to request the page and then serve it to the user...
  2. scat

    Simple Excel question

    dawnd3 that's neat. as with most things excel, there's always a better way. thanks. scat
  3. scat

    Simple Excel question

    select the 'split box' (top of vertical scroll bar or right of the horizontal scroll bar). the cursor will turn into double vertical bars with horizontal arrows when you're on it. click and drag it to where you want. then go to window menu and select freeze panes.
  4. scat

    #DIV/0! ERROR MESSAGE--DON'T WANT IT

    or you could array enter(type in the formula and then press ctrl+shift+enter simultaneously instead of just the enter key) =IF(A1:A5,AVERAGE(A1:A5),0)and format the cell as 0;-0; to get rid of the zero. not sure how an array formula compares to four function calls efficiency-wise. also, while...
  5. scat

    Splitting data from one cell into three cells

    or you could use text to columns (data menu), selecting fixed width option
  6. scat

    Reverse names and change one to upper case

    jmuscat check your post on mr excel :)
  7. scat

    Excel - have a csv file retain leading zero

    if they're all nine digit numbers you could custom format the worksheet as '000000000'before you import. i also vaguely recall a way to do this with text to columns but i'll have to go and find it.
  8. scat

    Distributing new font with a word document

    could you rename the new font to one of the ones already there but is never used and then try to copy it over, or is copying just a no-no no matter what?
  9. scat

    Help with Excel

    Probably unnecesary to suggest this now that xlhelp has provided a good solution, but you could also use text to columns (data menu) and set 'space' as the delimiter. Whatever you use, I agree with xlhelp that your gridlines disappearing is unrelated to his formula. If his suggestion of screen...
  10. scat

    very easy but i stucked

    fatih excel only allows 256 columns so you wouldn't be able to transpose any number of rows greater than that. that limitation aside, another option for transposing is to use paste special>transpose on the edit menu
  11. scat

    Trim Function

    you could use =SUBSTITUTE(A1," ","")
  12. scat

    Excel 2000 using a list as a database

    i may be missing something, but isn't this something you could do with data validation?

Part and Inventory Search

Back
Top