How to convert this type of numbers in one formula 1145 =1150 1141 =1150 1149 =1150 12458=12460

I would like to calculate a cumulative of: A1 = 3.2 B1 = 9.5 C1 = 6.9 I want D1 to be the result of the cumulative of A1, B1 and C1 only if they have a...

Hi when adding up a colum using sum instead of getting the total I am getting ### I can see the correct answer bottom right as usual but when I try to enter...

Is there an excel formula that will replace a number value with a line of text? Example if I type "1" into the cell it will be replaced with "final draft",...

I can set up a conditional format in one cell. I would like to copy that CF to all the cells in the column. Any way to do that in 2007?

Hi I have a column of part numbers which are of varying length and start with varying letters. I would like to add 'M' to the beginning of every cell so for...

Good afternoon folks, I'll try to keep this short. The formula i'm working with =-sum(c6:h6)+a6, is in cell b6. ? how can I enter a new value in a6 and have b6...

I am happily going along selecting certain cells with my mouse when, all of a sudden, a click of the mouse starts selecting five cells at a time. I don't...

Im really new here so apologize if this has been asked before. My problem is this: I have created a template file that will be stored on a share drive company...

how do i add a number to a range of cells? I need to add 11.27 to a number of different cells each with a different number in them

I am charting monthly call volumes in a line graph in which I have 7 series (a different line of business). Each series takes 12 cells of data,...

Hello, I have a template that generates info in it from a access database. I would like to have a window come up as soon as the excel file opens and ask to...

I have a group of cells for an inventory sheet. I want to prevent double or incorrect entry. For example, if there is any entry into cell F6 they cannot...

I need to set up a spread sheet to be able to get age, sex,service usage numbers, site utilisation, presenting issue e.g., drug and alcohol, region,...

Hi.. I tried to reset the standard color in Excell 2007. When using Excell 2003, I usually find it in toolsoptionscolorreset in excell 2003. How do I do...

Hi! I've checked a few threads on this matter, but they don't quite cover what I'm after. I have an Excel document with several columns full of words and...

Can I use IF formula to ccmpare time? Ex =IF (A4=24:00:00, "24")

where the template is stored

I have conditional formatting on some columns in my spreadsheet. I would like to put that same formatting on some rows. Is there a way to copy conditional...

I m a new user please detailed breaf for that