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 Mike Lewis 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. mjstout

    Autocad LT 2007- How do i delete layers?

    Hi Todd, When the dialog box opened I tried to delete some of the layers. I cannot delete any of them and I get a dialog box with the following contents. The selected layer was not deleted. The following layers cannot be deleted: Layers 0 and Defpoints The current layer...
  2. mjstout

    Autocad LT 2007- How do i delete layers?

    Hi, I'm able to delete layers in a dwg file by using the delete select funtion. I click an item on the layer I want to delete and the layer deletes. I get down to the 3 layers i want to print visible. When I print though or try to save the file all of the layers become visible again. How do...
  3. mjstout

    Making worksheet function to strip a cell of non number characters.

    Great input from everyone! Thanks a lot! I'm good now =)
  4. mjstout

    Making worksheet function to strip a cell of non number characters.

    Hi, I need to pull phone numbers from a cell in an Excel worksheet into another worksheet and eliminate non number characters. Copy paste won't work for me. There isn't a function in Excel that does this so I have to create my own. Substitute is the closest thing in Excel I've found but I...
  5. mjstout

    Excel Need to copy phone number from a cell stripping non number chars

    Lol.. I was trying to do something like that too. Thanks a lot John Ill run with that! Mike
  6. mjstout

    Excel Need to copy phone number from a cell stripping non number chars

    Thanks John that's a good start. Some of the numbers also contain (,),/, and x. Is there a function that can get rid of all non-number character? or a way I can create something like that? Thanks again! Mike
  7. mjstout

    Excel Need to copy phone number from a cell stripping non number chars

    Unfortunately copy and paste special will not work in this case because the import/export data from one phone is in a completely different format then that of the other phone. Copy and pasting I would have to do one phone number at a time and there are hundreds of contacts per phone. I need...
  8. mjstout

    Excel Need to copy phone number from a cell stripping non number chars

    Hi, I need to move contacts from a large number of BlackBerrys to Motorola i530 phones. I'm doing all of my conversion in Excel. Phone numbers from the BBs can look like this 916-357-7531. I530 phones don't accept non number-characters. Is there a function that will copy a number...
  9. mjstout

    Using calculations with the current date in World Writer

    Hi, I need to run a weekly aging report that will have a column showing how many calendar days between today's date and a date in the system of when a home should have closed escrow. So far I've set up a report in World Writer with a column displaying the date the home should have closed...
  10. mjstout

    Lotus Notes 6. Delete button puts a black x next to the email not del

    Hi, If I click the Delete button in Lotus, or hit the del key, or right click and delete, the message gets a black X net to it instead of moving to the trash. I can drag a message to the trash though. Please help, mike

Part and Inventory Search

Back
Top