-- sivaprakasam

I created a worksheet for each month for daily sales. Each worksheet has 3 colums that are totaled at the bottom. I would like to creat a new worksheet that...

Here's my formula: =YEARFRAC(B3,$D$2) I get an error (#NAME$) What am I doing wrong? Thanks, Doug

In a form, I have a Years of service note. It works as it should except for the first year of work, which would really be "0" years for the first year. D48 ...

I am a beginner and I have an audit to do. I will need to add up all of the yes and no answers which are in a single column Thank you in advance ferde

I have one column with yes or no in each box. Is there a formula that will count the number of yeses and put it in a box for me? so I get "YES 203" "NO 42"

I have for the most part converted to Excel but have a simple macro that on the surface cannot be converted. The Lotus macro used a database, template and...

You Need Fast Money ?????, visit http://dinero4ever.blogspot.com Now!!!

That didnt really answer my question. i need to know if you can enter data in one area and it fill in automatically into another

When I type 01243 32186 (telephone number) it is left aligned in the cell and exactly as it is typed. As soon as I move the cursor away from that cell, the...

I import a comma separated value file into Excel 2003, on a regular basis. The file consists of eight columns, one of the columns is just telephone numbers,...

Hi, (Excel 2003) I have a workbook where sheet 1 is called 'Raw data'. Sheets 2 to 13 are then called 'January' through to 'December'. I use the following...

Hi everyone. I have created a new custom number format that replaces 0 values with a dash (-). But there's a problem with this. In cases where the zero...

How do I make my worksheet display zero's as slashes (-)? One worksheet I have does it but the other display's zero's and I've compared fonts,...

Hi when i type a number into a cell ie 6 when i leave the cell a zero is automatically added. I dont want this zero to be added -- des

I would like to be able to select a portion of my spread sheet and then have a macro that would search every cell in the selected area: if the cell is blank...

I am doing a pie chart using a quick style design that shows the lines in between the different percentages. Some of the charts show a percentage with the...

I copied a formular down 10 cells for future input. The cells are all showing 0.00, until I enter a value on the other side where the calculation will...

I have a spreadsheet with data imported from a database program. One of the columns is the zip code. Some of the zip codes have zip-plus-4 and others just...

Hi. I understand how to allow o first digit zip codes, but I am importing from my web site and I need to set up the 0#### condition "globally" for Excel. Is...