"mayayana" wrote: There's actually a method more specifically designed for checking odd/even numbers: If (x Mod 2) = 1 Then '-- number is odd Yes, if you are sure that your numString is correctly formatted coming in, then you could do If CINT(numAsString) MOD 2 = 1 Then numAsString = Right("0" & (CINT(numAsString)+1), 2 ) That is, don't change numAsString if you verify
On Tue, 12 Aug 2008 21:38:17 -0700, Ms. Latte <MsLatte@discussions.microsoft.com> wrote: When I do the price, there are two step involve 1. I have to convert USD to Thai currency by multiplying with specific number. 2. When i got the Thai currency (which may have demicle) , I have to round up or down to these number i.e. it must end with 500, 700 or 900. 0-299 round down to 900
>Number: 39205 Category: toolchain Synopsis: gcc-4.1.2 shifting a boolean may cause bad sign extension Confidential: no Severity: serious Priority: low Responsible: toolchain-manager State: open Class: sw-bug Submitter-Id: net Arrival-Date: Fri Jul 25 14:15:00 +0000 2008 Originator: Michael van Elst Release:
On 07/23/08 15:03, eSilviu wrote: still to much work for such a simple thing... transparency is the best thing in v5, but as it now - it's almost unusable. I (we) want transparency for layer, not for colors. This is the way all other CAD's are working! Here's a small ULP that implements changing the transparency for a particular layer: int Layer = strtol(argv[1]); int Alpha
Try this... It will randomly pick a cell from the selected cells. The first is a macro, the second is a worksheet function. Option Explicit Sub choose_random_cell_from_selection() Dim MyValue Randomize ' Initialize random-number generator. MyValue = Int((Selection.Count * Rnd) + 1) ' Generate random value between 1 and 6. MsgBox Selection(MyValue) End Sub Function choose_random_cell