Values In Sheets Gets Divided By 10

Mar 8, 2009

Excel 2007. Trying to enter a number in a cell in a spreadsheet

(a) opened with the "blank workbook" (new spreadsheet)
(b) created with Excel 2003 and opened in excel 2007
(c) created with Excel 2007 and emailed by someone who isn't having that problem on his Excel 2007 installation

Any number I type in is automatically divided by 10. The only way I seem to be able to prevent this is by entering a decimal point when I enter the number. Have tried several different formatting options, although in 2007 I can't seem to find how to "uncheck" fixed decimals. Tried General formatting and fixed decimal formatting, and nothing seems to work. Looked for hidden macros, none show up when I click on View Macros.

View 2 Replies


Divided Sums Of 2 Columns With Denominator Changing Based On Blank Values In Column

Dec 31, 2013

I am trying to create a sheet on that takes the sum of 1 row divided by the sum of another row removing numbers from the denominator if fields are left blank. Hard for me to explain so here is an example:

Column 2
Column 3


Leaving a blank value in column 2 makes it read 4/6 giving me 66%, Column 3 giving me 50%.

What I would like it to do is if there is a blank value in any column remove column one from the denominator.

Upon completion the total output percentage for column 2 should be 100%, and column 3 should be 75%.

View 3 Replies View Related

#DIV/O! Error Divided By Zero

Jan 21, 2010

Hi, I found another problem with my pool spreadsheet.

In the Calculation worksheet, region P3:AU27 ;

Within that table, it would be nice to have the formula's filled for the entire table but as it stands, I have to drag the formula every time we play, I'd like to lock that page so I don't make a mistake in it. Because I get an #DIV/0! error that screws up all the results.

Is there a way to fill that table with the formula so I don't have to touch it and the results will be calculated properly?

The function of the said table is to give the players their true average in percentage. It calculates the amount of points they accumulated individually everyday they played, compares to the total possible points in that day and returns an average.

So to recapitulate, if I drag the formula's form " Calculations " " AI " to " AJ ", I'll get errors if there was no score entered in the Player DATA sheet. Any way to avoid this ?

BTW, I'm using excel 2007.

View 9 Replies View Related

Divided Into Specific Numbers

Apr 18, 2008

to work out a formula to achieve a specific breakdown when 2 values are divided. I apologise for the vague explanation, please refer to my attachment for better understanding.

View 14 Replies View Related

Find An Integer That Can Be Divided By 6

Oct 12, 2009

How to make A1= A2xA3 and round the result to the higher integer that can be divided by 6 ????

View 3 Replies View Related

Totals Divided By Month

Feb 22, 2012

I have a list of parts ordered with the order date in column I

I would like a total of ordered parts for january from the order date in column I

Is this an easy formula?

View 3 Replies View Related

Showing A Blank Cell When The Sum Is Zero. (Divided By Zero Error)

Aug 27, 2009

I want a cell to be blank if the sum is Zero. I am getting a divided by zero error, I tried this formula: =IF(SUM(C6/D6)=0,"",SUM(C6/D6))

View 4 Replies View Related

Single Cell In Column Be Divided Into Two Parts?

Nov 28, 2012

Question is this, "can a single cell in a column be divided into two parts?"

View 14 Replies View Related

Excel 2010 :: Data Gets Divided By 10 When Put In A Graph

Dec 12, 2012

I have a set of data (numbers) I want to include in a bar chart. The numbers appear fine in the table. When I create the chart and sets the data (the cells excel goes looking in to create the chart), the values in the cells are divided by 10 for some reason I can't understand.

I tried to create a new file and a new chart, and the issue does not repeat.

I do not know where to look in that specific file to prevent Excel from dividing every number by 10 when I create a chart.

View 2 Replies View Related

String In Column A To Be Divided Into 2 Strings If Length > 50

Apr 8, 2013

I have a set of data in Which in column A is the name of organisation.

If string in col A is longer than 50 I need to split in and put in col B.

That would be simple however I need to do it in a smart manner: i.e. cut it to the nearest full word.



Incorrect; length = 98

Correct; trimmed down to 48.

My question is about formula that can detect spaces and depending on those trim the string down adequatly:
to 50 if 50th char is preceeded by space; if not then check where is the next space going towards left. Once you find it cut the string there.

What formula I can use to get desired effect?

View 9 Replies View Related

Lowest/Minimum Divided By Highest/Maximum

Aug 21, 2006

I have a sheet of about 15000 rows made up of about 1300 groups( events) and 40 columns, a miniature of which is attached.

In column1 I have the event identifier,column 2 contains a score or rating for each contestant in each event.,in column 3 there is a code for each competitor,either orange or pink.There will be at least 1 orange and 1 pink in each event.

column 4 is the one I want to create by formula,the lowest pink in each event
divided by the highest orange. I have titled this column the spread. I have filled column 4 manually to illustrate what I mean.

View 6 Replies View Related

Select Multiple Sheets And If Value In Cell Is True Then Copy Values In All Sheets And Hardcode Data

Feb 26, 2012

I have a workbook that updates from external source and creates sheets depending on a cell range.

I have put tab 1 and tab 0 on either end of where the new sheets will be inputted, will never know how many sheets

What i need to happen is if someone fills in "complete" in A7 in my "summary" sheet then the values in row 6 in all the other sheets get hardcoded. This needs to happen from A7 down to A26, so A8 = complete then copy row 7 etc
This is what i have so far

I get compile error here ........Sheets(ArrSh(1)).Activate

Also need it to work for all the other rows.

Sub hardcode()
'Sheets("Summary"). Select
If Range("a7") = "complete" Then
Sheets(Array("1", "0")).Select

[Code] ......

View 2 Replies View Related

Macro To Fill Cells For Number Of Times With Value Divided

Jun 3, 2014

I need a macro to do the following

Assume A1 has 100 & B1 has 20

The macro should divide 100 by 20 & then fill 20 for number of times I get as the answer starting from B3 9 in this case its 5 times

E.g.: B3 , B4 , B5 , B6 , B7 should be filled with 20

If A1 has 200 & B1 has 50

B3, B4 , B5, B6 should be filled with 50

View 1 Replies View Related

Transfer Numbers From Userform Divided By Search Number?

Jan 25, 2014

In sheet lists I have a list of names and to the next column, I use 0ne 0f these threee options 1/3 OR 2/3 OR O(zero). So what I need is this When a user choose name from the combobox and then type numbers in textboxes, I d; like these numbers to transferd in data base column M, but if number of the specific customer in Lists Sheet is 2/3, then the 2/3 of the choosen numbers should transferred rounded to the nearest biggest number. Example: If I choose Maria, and type 30--10--15--25--40, in text boxes, then numbers 20---7--5-17--27, should transfer in database column M.

If i choose Stevens, then numbers should tranfered as ii is. No chance.

View 10 Replies View Related

Extracting Numbers From Cell Divided By Multiple Delimiters?

Jan 30, 2014

I would like to extract multiple numbers from a single cell. The cells contain -, /, and blank spaces are delimiters. An example is 4 - 3 1/4 and because of the way they use that number, it really means 4 inches and 3.25 fifths of an inch (3.25/5 inches) which is weird. I want to go through each cell and store the 4, 3, and 1/4 as variables so I can then manipulate to convert them to the proper inch value (I can perform the conversion code, I just need to know how to set those variables in the cell). And I would like it to automatically do it when a cell has been changed. formatting to maintain overall table width dimensions so if you know anything about that,

both cells are blank

4 - 3 1/4

cell value is enter in on the left

4 - 3 1/4
converted cell value appears on the left

View 2 Replies View Related

Formula Based On Dates - Calculate Annual Salary Divided By 12

Aug 6, 2014

I've got a spreadsheet where the start date is amendable and this is what I wanted. E.g. start date is Jun-14 and I want the formula to to calculate annual salary divided by 12 in each month from June onwards until Mar-15 (Financial year is April to Mar) and the same way to not show anything in April or May as they started in June... How can i achieve this please as I tried IF statements and it doesn't recognise dates and years...

Link: [URL] ....

View 1 Replies View Related

VBA Export Data To Path Depends Upon 1 Combobox Values Sheets And 2 Textbox Date Values

Jun 5, 2014

I have set of user-form contains with Combox & 2 textbox and to generate report one cmd button

I have 3 different sheet contains report of daily activities ( Dispatch,Closed,Cancel)

If Dispatchcalls Select In Combobox1 ,Then Filter Start And End Date In Two Textboxes Then Click Cmd" Export Data To Excel"Extract Data from dispatchcalls Then Save Data Into Excel File As "Dispatchcalls".

If Closedcalls Select In Combobox1 Then Filter Start And End Date In Two Textboxes Then Click Cmd" Export Data To Excel"Extract Data from Closedcalls Save Data Into Excel File As "Closedcalls".

If Cancelcalls Select In Combobox1 Then Filter Start And End Date In Two Textboxes Then Click Cmd" Export Data To Excel"Extract Data from Cancelcalls Save Data Into Excel File As "Cancelcalls".

"C:UsersmaniDesktopNew folderLenvo_ReportsONSITE CasesVlokupuf" This is path i stored existing 3 file dispath,closed,cancel

View 3 Replies View Related

1 Row Cell Covering 4 Rows But Next Column Divided In Separate Rows

Jun 5, 2014

I am working with an excel spreadsheet. There is a column for "name", and then the next column is for medical condition.

If the same patient has multiple (say, 4) conditions, the rows for "name" are combined into a single cell(let's say, a cell going from row 2 to row 5, witha a single name in the combined cell) , with the next column having four different cells adjacent to the single cell (cell 2 has "bleeding", cell 3 has "fever", cell 4 has "diarrhea", and cell 5 has "rash"). Some patients have only single conditions, single cells.

Will this mess up COUNTS and COUNTIF?

Is there a way to split the combined cell2-5 for ''name" into four cells all containing the same name?

View 4 Replies View Related

Rows Similar Data Divided By Blank Row To Delete Data If There Are 6 Or Less

Apr 2, 2014

I have a lot of rows of data all divided with an empty row and if they are 6 or less all rows need to be entirely deleted any 7 or above need to be kept.

View 2 Replies View Related

Lock Sheets With Formulas And Lock Sheets With Values

Jul 2, 2009

do you know if there is vba code to lock formulas so someone sees but does not touch and the same for values see but cant change??

my sheets with formulas are SUMMARY and Sheet2

sheet with value is TABLE

View 9 Replies View Related

Calculating Values Across Different Sheets

Jan 9, 2010

I have a large spreadsheet with about 250 worksheets, each of which contains among other things a row of values that require further calculation (the values are being entered manually). The format of these rows is simple:

Count 1 3 2 4 3 2

Given that these rows are identical in size and they are in exactly the same cell positions in each of the 250 sheets, I need to find a way of getting each of the values entered in each of the 250 sheets automatically copied across to a different sheet and added to an existing total. In my limited understanding of Excel I consider such operation to be similar to a sum function which involves multiple cells in multiple sheets. Despite my best efforts Iíve yet to find a solution to what may be a very simple problem.

View 2 Replies View Related

Return Values From Different Sheets

Dec 9, 2009

I pull a report (Form2), and I want to import values into another sheet (Form1).
From Form2, I want to import the cell value in $D# based on the name in cell $C#, when the name in $C# matches the value in D2 on Form1. Ultimately, the value from $D# will return to cell G5 in Form1.

View 2 Replies View Related

Lookup Values In Two Different Sheets

Nov 10, 2008

I have two worksheets with different data in them. In worksheet "Sheet1"

A B C (?)
1 01 03
2 01 03
3 01 03
4 03 03
5 02 04

In worksheeet "Sheet2"

1 01 03 Mechanical Engineering
2 01 04 Aerospace Engineering
3 02 03 Electrical Engineering
4 02 04 Electronic Engineering
5 03 03 Hospitality

What i would like to do is to fill in the C column in Sheet1 by checking if the value for A and B columns match up with those in Sheet2, then copy the value in C column and put into C column in sheet1. for example if A1 = 01 and B1 = 03, then it is Mechanical Engineering. I was thinking of using VLOOKUP but don't think it'd take "if else" criteria.

View 2 Replies View Related

Matching Values Between Sheets?

Jan 4, 2012

I'm trying to store a value in ColumnA Row1 Sheet1 in a variable and check to see that value exists in Sheet2. If the value is in Sheet2, I want to copy the information in Row1 Sheet1 and paste it in the row of the matching value in Sheet2. I need to then check the value in ColumnA Row2 Sheet1 and check again for it in Sheet2 and I need to continue to do this until the data ends in Sheet1.

Dim x As String
Dim y As String
A = 2
B = 2


The above is the code I've been trying to use. It has two flaws:

It won't let me copy into the row of Sheet2 (not a big deal though)The rows get all mismatched and it doesn't actually search ALL the rows in Sheet2 so it misses some of the values that actually DO match (the big issue) I've racked my brain for hours trying to figure it out using the above method and I think I've reached the point where I'm overthinking it way too much. I also found the "Find" method but I couldn't quite teach myself how to use it.

View 9 Replies View Related

Updating Values On Three Sheets

Jul 1, 2013

I have three sheets of data which require different values. What I'm looking for is for the other two sheets to be updated when I change the values in the field 'Option_Group_IDs' in the productdata-army-to-merge.csv file.

The two fields in the other two sheets to update are the optGrpID filed in the optiongroup-data-army.csv and the optGroup field in the optiondata-army.csv




[Code] ..........

View 1 Replies View Related

Compare Values From Two Different Sheets

Sep 28, 2007

If the record exists in both sheets then compare the value in col. H for both records, if the value is different then copy the entire record to a third sheet.

There are 16,000 rows of data to do comparisons.
I have been thinking about a Vlookup method as one choice, my thought is this going to be slow.
I have read about vba having some comparison choices, vbbinary, vbtext, but I do not have any knowledge of this, so cannot intelligently choose what options to begin w/.

View 9 Replies View Related

Summarizing Values From Other Sheets

Oct 3, 2008

In the first sheet (EQ MOVES) I have:
Column A contains a list of some 300 different pieces of equipment.
Column D is where the foremen enter the job number (4 digits) and job name of where the foreman wants the equipment to go the next day.

In the second sheet (PERSONNEL MOVES) I have:
Column A contains all employee names.
Column D is where the foremen enter the job number and job name of where the foremen want the employees to go the next day.

In the third sheet (SUMMARY) I have:
A box in A1 where I type in a job number (4 digits) but no job name.
A2 says "EQUIPMENT and B2 says "PERSONNEL".
A3 and below should list all equipment to go to that job listed in A1.
B3 and below should list all personnel to go to that job number.

View 9 Replies View Related

Compare Values In Different Sheets

Nov 28, 2006

I am in the process of comparing values between two sheets.

I would like to search on column A on both sheets and check whether there is a corresponding value in the sheets.

If there isnt then I would like to take that record and put it into a new sheet.

My code is as follows

Public rowcn
Sub auto_open()

Dim iCounter As Integer 'counter as integer
data_sheet = "CASES_ANALYS"
data_sheet2 = "A_CASES_"
target_sheet = "Final Report"

Currently I'm just displaying it in a msgbox but would like to paste the specific record into another sheet but not sure how to do this.

So far this code doesnt work

View 9 Replies View Related

Rank Values From 2 Sheets

Feb 28, 2008

I have two sheets of data and would like to rank according to the order in which the data fit on both sheets. Rank function only seems to allow one sheet at a time.

View 9 Replies View Related

Lookup Values From Separate Sheets?

Jun 3, 2014

I am in the process of creating a Phone Roster for my unit. On Sheet1 is their administrative data (Name, Position, Phone Number, etc.). What I am attempting to do is use a formula to find the persons name for that position and place it in the appropriate position and then their phone number below.

Admin!H:H contains the positions
Admin!B:B contains their name
Admin!N:N contains their phone number

I believe the following is what I need =LOOKUP("Operations NCO",Admin!$H:$H,Admin!$B:$B) and it works, but only for the first person on Sheet 2. After that it is random. If there a different formula I need to use to make this work?

When I get the phone number I used =LOOKUP("Operations CO",Admin!$H:$H,Admin!$N:$N) and the same thing happens. It works for the first person and everything else is incorrect.

A problem is the Admin sheet is listed alphabetically, not by position, so I cant use a specific cell to copy the data. I need the formula to find the position, then find the name and phone number of the person in said position.

View 5 Replies View Related

Copyrights 2005-15, All rights reserved