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 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. Ldegeus

    Removing Excel styles in Excel 2003

    @jflaurin: As far as I know the mid function is only for selecting a part of a string. So I don't think it's applicable here @Skipvought I know this article. And I know how to delete styles, manualy or with VBA. But I don't know how to determine which styles are used, double or what so ever and...
  2. Ldegeus

    Removing Excel styles in Excel 2003

    In our office some of us use Excel 2003 and some Excel 2007. Sometimes when we copy data form one excel sheet to another we get a warning that there are to many styles and we can't past. Now I created a simple program that removes all the styles but then all formats are removed. Now I want to...
  3. Ldegeus

    Using decimalseperator in Excel

    thank you for your info. It's sad indeed that it only takes affect after restarting Excell. I took an other solution. With replace I change all "." with ",". Its only one column and the max value is about 200 so I have no problems with thousands. And I don't save the changed data so thats no...
  4. Ldegeus

    Using decimalseperator in Excel

    I found out that in the given version this doesn't work. In later version this command is available.
  5. Ldegeus

    Using decimalseperator in Excel

    I want to change the decimalseperato in an Excel sheet. I want to do this with Application.decimalseperator="," or Application.Decimalseperator="." but for some reason the application doesn't ecccept it. I think it has to do with some library I didn't install but I'm not sure. Which library has...

Part and Inventory Search

Back
Top