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!

Recent content by JTuc

  1. JTuc

    Changing Text to Numerical Value

    Skip, I have a problem similar to Candy's. I have a bunch of shop order numbers that are formatted like "400000148" that get formatted as "4E+08" when I copy from one column and paste into another. When I use your tickle trick with the F2 key this works. Is there a way...
  2. JTuc

    NOVICE NEEDS MACRO HELP

    I made a macro (Excel 2000) to speed up my repetitive task. It worked for a while, but "poof" the macro was no more. I had saved it in the personal workbook. Now when I go to look for the macro the personal workbook is not an option to select. I still have the options to all open...
  3. JTuc

    TARGET LINE ON BAR GRAPH

    Thanks Pepelemokko, and Ken, I found the website to be a big help. Jason
  4. JTuc

    TARGET LINE ON BAR GRAPH

    I have a bar graph in excel. I want to put a horizontal line across it near the top to show what my goal is. Any one have suggestions for how I can accomplish this?
  5. JTuc

    how can I find a lost workbook?

    No I'm afaid not. I have since opened up lots and lots of files. I've tried that already and also looking in the history to find it with no luck.
  6. JTuc

    how can I find a lost workbook?

    My boss came into my office and created a workbook on my computer. He then had me link worksheets from other workbooks to it. I linked about 15 other workbooks to this new workbook. Dummy me... I forgot to note the name of the workbook my boss created, now he's not around to ask. I need to open...
  7. JTuc

    delete all hidden sheets

    Beddows, I'm not quite as advanced as you are, so I don't quite get this. Can you explain to me (laymans term please) where it is that you copy and paste these codes?
  8. JTuc

    clear the cells--but NOT the formulas--

    Thanks all! The tip from XLhelp worked for me. Zanthras, I believe yours may also work, but your answer was much too advanced for me, my fault not yours. The uncheck the text comment was a big help though. Thanks again!
  9. JTuc

    clear the cells--but NOT the formulas--

    I made a big spreadsheet which has subtotaled rows and subtotaled columns. It was used to record data for the entire year. Now I want to repeat this for 2003 with the new data that I will be accumulating. Can I copy and paste my 2002 spreadsheet leaving all cells blank except the headings, but...
  10. JTuc

    repeat a header on multiple worksheets

    Thanks onedtent for your rapid response, it worked like a charm!
  11. JTuc

    repeat a header on multiple worksheets

    I have a workbook with multiple worksheets inside of it. I want all of the worksheets to have the same header. Is there a quick and easy way to do this, without having to go into each worksheet and type in the header?
See more

Part and Inventory Search

Back
Top