Posts by jledlow

Re: VBA Command Button insert formula

Thanks skywriter, that worked. All the quotes and "&" is where I was going wrong.

I am trying to have a command button insert a formula into a group of merged cells when clicked.
Attached is the sample excel file.
When Name1 button is clicked I would like it to insert the formula that is currently in b2:d3.
Thanks for any help.

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.

Re: Automatic Accounting Format

The custom formatting you provided does what I need it to do. However, I have another group of cells that add up the seperate totals. Cash, Coins, Credit Cards, and Checks and what I noticed happening was even though the cell displayed .50, the total cell was showing it as 50.00.

Attached you will find the worksheet I am creating.

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.

Thanks
jledlow

Re: Can't get the serial dates to convert to formatted dates.

Hi Maqbool,

Thanks for the quick reply. I tried the formula and it worked!

Sincerely
jledlow

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.