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!

  • Congratulations SkipVought 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: bigpapa
  • Order by date
  1. bigpapa

    Word 97

    It is my understanding that documents open in the view they were saved in - the view is saved with the doc. I may be wrong, since I've been using Word 2000 for a while now, but I believe 97 worked that way as well.
  2. bigpapa

    Printing a large word doc

    My guess is that it is not a Word problem, but a Windows problem. There is a counter that appears on the status line (bottom of screen) when a document is being queued to print. If it counts to 84, but printing stops after 8 pages, there is a problem in how Windows is communicating with the...
  3. bigpapa

    Excel Formulas

    If you really want to break the text into pieces, using LEFT and MID (as repete suggests) will work, but gets a bit clumsy to manage if you want to split it in more than 2 pieces - that is, for a very long string, split into 20 per cell until it's all used up??? Is splitting it into separate...
  4. bigpapa

    Excel Formulas

    The answers may differ depending on why you are trying to do this? And in particular, what type of data are you working with? I would expect from the description that it is text, but if it is (big) numbers, the answer changes dramatically. Can you give more info?
  5. bigpapa

    Word 97

    You haven't said if you are starting a new doc via File...New Document or the taskbar button. Assuming you're using the File menu (since the New button always results in a default blank document), you say the wizards are 'in system'. You need to check the path to File Locations in the Options...
  6. bigpapa

    Excel field has three spaces I need to remove from collumn.

    One simple answer is that the TRIM function should strip off extra spaces. However, your explanation of the problem is a bit puzzling. You say the data are 'numbers' yet LEFT(A1,9) only extracts 4 digits. This would only be true if the data were a string with 5 leading blanks. But if that were...
  7. bigpapa

    Excel 2000:Time Sheet date lookup when a pay period is input

    Unless I misundertand the question, sounds like the HLookup function will do what you want (for dates). I won't go through all the details here since you can search the Excel Help for HLookup and it will explain exactly how to set it up.
  8. bigpapa

    Word: SaveAs Activates a Previous Window

    Need some clarification: <br>&nbsp;&nbsp;This only happens on this ONE machine? Only SOMEtimes?<br>&nbsp;&nbsp;Is it always the SAME folder, or any folder with Word files?<br>&nbsp;&nbsp;Is it always the SAME file, or does it happen with different Word files?
  9. bigpapa

    Excel97, How to find new end of sheet?

    Save the file. <br>(This resets the size??)
  10. bigpapa

    .doc files changing to temp files when saved

    I don't think it's renaming the file. When you open the file, Word97 creates a working version as a temp file in the same folder. That will remain there until you close the file - then it will be automatically deleted. However, the original file should still be there (though it will probably be...

Part and Inventory Search

Back
Top