Posts by jledlow

    Re: Fix Decimal Places on Entry

    Thanks for all the replies and help. They will just have to remember to enter the decimal value in the cells., or at least until I learn a little about VB.

    Thanks again for all the help.

    I am creating a Daily Cash Count worksheet for a business to do their daily closeout paperwork. What I am trying to do is automatically apply decimal formatting to a cell. Examples, if they count 60 cents in nickles and enter 60 in the cell, it automatically converts it to .60. And if they count 7.50 cents in quarters and enter 750 in cell it automatically would convert it to 7.50.

    Thanks for any help with this. I've tried all the currency style formatting with the cells, but nothing. Also I am using Excel 2003 to create this worksheet.

    Re: Conditional formatting in an adjacent cell

    Thanks Krishnakumar.
    I tried the formula and it does exactly what I need. Since I am still in the learning of these more complex formulas, could you explain how the above formula accomplishes the results. I've always been one to ask questions when I want to know how something works.

    Thanks again for helping.

    I am creating a drawer balance sheet for a business. I have one cell, lets assume it is "H11", that will have three conditions which are: 1. greater than zero, 2. equal to zero, and 3. less than zero. What I want to accomplish is I want to have cell "G11" to display different text depending on the condition of h11. For example if H11 is greater that 0 I want G11 to display OVER. If H11 is equal to zero I want G11 to display IN BALANCE. and if H11 is less than zero I want G11 to display SHORT. Any help would be greatly appreciated.


    I'm creating an employee time sheet spreadsheet. I have the dates in column b14 to b20, which are the seven days of the week, formatted correctly as mm/dd/yyyy. What I am trying to do is to have another cell display the pay period by copying the values from b14 and b20 into a single cell (g9) and displaying the values in this format "mm/dd/yyyy to mm/dd/yyyy". The formula I am using is displaying the dates as the serial date values and I cannot get it to format the dates as mm/dd/yyyy. Any help would be greatly appreciated. I have attached the spreadsheet for anyone that might need to look at it. You will see that in cell g9/h9 which have been merged, what is going on.

    Spreadsheet has been removed since question was answered.