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

    VBA/First character as capital

    CBFISH, next macro will do that in a selection, p.e. Sheet1!A1:F12 Sub MakeCapital() Range("Sheet1!A1:F12").Select For Each cell in Selection cell.Value = StrConv(cell.Value, 3) Next End Sub That's all Jan D.
  2. jdol

    VBA/First character as capital

    Thanks Golom, that's what I was looking for!! Jan D.
  3. jdol

    VBA/First character as capital

    Hello, I'm looking for a function in VBA to present the first character of a word as a capital. In the Dutch-version of Excel2000 exist the function "BEGINLETTERS(A1)" that presents the first characters of all words in cell A1 as a capital, and that's exact what I'm looking for. But now, I will...
  4. jdol

    Performing calculation on time

    gapiesco, I understood you're dividing by minutes. But why? Your goal is a percentage of a month; my formula deals with minutes and seconds too, so y'll always get the exact percentage. Try it!
  5. jdol

    Performing calculation on time

    The solution for your problem is quite simple. If you want your percentage in a cell, give this cell the percentage-format and the formula: '=AH12/30' (or 31 in p.e. january, or 28 in february). That's all!!
  6. jdol

    Excel2000: number format problem

    Yes, xlhelp, that's the solution! Thanks Jan D.
  7. jdol

    Excel2000: number format problem

    I,m using Excel2000 on 2 PC's, one with Win98SE (NL), and one with Win98SE (UK). On both machines all Win regional settings and Excel format- options are the same. But on the machine with Win98SE (UK) an integer (p.e. 5) will allways be displayed as 0,05 in stead of 5. Who knows what's the...

Part and Inventory Search

Back
Top