Microsoft Excel 2007 Home and Student Edition for PC Logo

Related Topics:

Posted on Nov 10, 2009
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

When I enter a number in a data field it is divided by 10. If I enter 100, 10 shows in the data field. This is true for a new spread sheets and old ones. Why?

1 Answer

Norman Al-Anbar

Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

  • Master 630 Answers
  • Posted on Nov 10, 2009
Norman Al-Anbar
Master
Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

Joined: Sep 07, 2009
Answers
630
Questions
1
Helped
164893
Points
1759

You have the memory on check the setup on the auto fill

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1helpful
1answer

My hp50 calculator only will give me fractions like if I put in 50 enter divide 3 it answers with 50/3. Sometimes it gives me an actual number when I divide something, but usually it gives me fractions,...

Press MODE to bring up the mode screen. Press F3 to bring up the CAS screen. Use the cursor keys to move to the Numeric field. Press F3 if necessary to check it. Move to the Approx field and check this also if necessary. Press ENTER twice to save the changes.
3helpful
1answer

Solve a matrix of complex numbers using ti89 or any other ti calculator

Well, the equation is Ax=b and we want so solve for x
There are several ways of entering the data, but this is one way
Code: A=[15+35i 29+1i; 46+13i 62+3i]
b=[0;0]
x=A\b which has the trivial solution x=[0;0] (the ";" means "next row", a space next column.) To input a matrix use APPs then Data/Matrix Editor then New. Then change Data to Matrix. Put in the name such as "AA" in the variable field. Then enter row and column dimensions. Then edit as a spread sheet. Use F6(util) to delete a column or row. To manipulate matrices, exit the matrix application, then go to MATH then Matrix. Notice that J(RowOpps) is available. Good luck and thank you for using FixYa! We would sure appreciate a 4 "thumbs-up" rating for this answer. Happy holidays!
0helpful
1answer

This is so easy but I've forgotten. I have an old manual Casio caluculator. I just want to divide a series of numbers by 4. I can't seem to figure out how to do it. Any ideas? Thanks, Julia

If your calculator has the capabilities to do constant calculations here is how you perform calculations with a constant.

  1. Enter the constant (4)
  2. Press the operation key (/) once.
  3. Press the operation key (/) a second time.
  4. Your calculator may show a k in its display (LCD)
  5. To divide a number by 4, enter the number and press =
  6. To divide another number by the constant (4) , Enter the number and press =
  7. Keep entering the dividends and pressing =
I hope it works for you.
0helpful
1answer

How do you get the spread sheet to keep the zero when you enter zip code with a leading zero

Spreadsheet software automatically assumes any numerical data entered as a number. What you need to do is to tell the software to consider tsome selected cells entries as a text. To do so
1. Select the cell, column or row in which you right your zip code
2. Right click on your selection and click on format cells...
3. On the coming dialog box, under the Number tab click Text for the category list
4. Click Ok. and you are done.
0helpful
2answers

Count the number of open and closed order status per owner

My suggestion is to use a Pivot Table.  Follow these instructions:
Click on column A1 - then in the menu bar click DATA > Pivot Table and Pivot Chart Report.  

Click NEXT on step 1 of pivot table wizard.
For step two you will want to highlight all of the data on your sheet.  then click next.
Choose NEW WORKSHEET for step 3 of the pivot table wizard and click finish.
Once the Pivot Table sheet opens, drag the STATUS field into the top left corner of the pivot table view, where "drop column fields" and "drop row fields" meet.  Next drop another instance of the STATUS field into the "drop row fields here" column.  And lastly drop the OWNER field into the "drop column fields here" section.  You should now be viewing a report showing you exactly what you were looking for.
Regards,
Joe


0helpful
1answer

Validation code using single loop for multiple fields in javascript

As example, use it:

JavaScript Form ValidationJavaScript can be used to validate input data in HTML forms before sending off the content to a server.
Form data that typically are checked by a JavaScript could be:
  • has the user left required fields empty?
  • has the user entered a valid e-mail address?
  • has the user entered a valid date?
  • has the user entered text in a numeric field?
Required FieldsThe function below checks if a required field has been left empty. If the required field is blank, an alert box alerts a message and the function returns false. If a value is entered, the function returns true (means that data is OK):
function validate_required(field,alerttxt)
{
with (field)
{
if (value==null||value=="")
{
alert(alerttxt);return false;
}
else
{
return true;
}
}
}The entire script, with the HTML form could look something like this:
<html>
<head>
<script type="text/javascript">
function validate_required(field,alerttxt)
{
with (field)
{
if (value==null||value=="")
{alert(alerttxt);return false;}
else {return true}
}
}function validate_form(thisform)
{
with (thisform)
{
if (validate_required(email,"Email must be filled out!")==false)
{email.focus();return false;}
}
}
</script>
</head><body>
<form action="submitpage.htm"
onsubmit="return validate_form(this)"
method="post">
Email: <input type="text" name="email" size="30">
<input type="submit" value="Submit">
</form>
</body></html>
E-mail ValidationThe function below checks if the content has the general syntax of an email.
This means that the input data must contain at least an @ sign and a dot (.). Also, the @ must not be the first character of the email address, and the last dot must at least be one character after the @ sign:
function validate_email(field,alerttxt)
{
with (field)
{
apos=value.indexOf("@");
dotpos=value.lastIndexOf(".");
if (apos<1||dotpos-apos<2)
{alert(alerttxt);return false;}
else {return true;}
}
}The entire script, with the HTML form could look something like this:
<html>
<head>
<script type="text/javascript">
function validate_email(field,alerttxt)
{
with (field)
{
apos=value.indexOf("@");
dotpos=value.lastIndexOf(".");
if (apos<1||dotpos-apos<2)
{alert(alerttxt);return false;}
else {return true;}
}
}function validate_form(thisform)
{
with (thisform)
{
if (validate_email(email,"Not a valid e-mail address!")==false)
{email.focus();return false;}
}
}
</script>
</head><body>
<form action="submitpage.htm"
onsubmit="return validate_form(this);"
method="post">
Email: <input type="text" name="email" size="30">
<input type="submit" value="Submit">
</form>


P.S.: If this information was helpful, please rate this solution.
</body></html>
0helpful
1answer

HELP with macro config

Hi Hss Holdings,

The easiest way to do this is to use a formula called vlookup. You need to have the raw data some where in the workbook, but it can be a separate sheet. Put all the raw data in a table, make sure the account number is on the furthest left column, then start entering the formulas

vlookup(value_to_find, table_to_check, column_index_number, range_lookup(true/false))

value_to_find = the value you want to find on the left most column of the table
table_to_check = the table you want to find the data from
column_index_number = the column number of the data field you want to return into this cell, 1 = the left most column.
range_lookup = false for an exact match, true for the nearest match

Say the table is on sheet2 between A1 and E300

B15 is whatever you type, so no formula needed here
B12 =VLOOKUP(C1,Sheet2!A1:E300,2,FALSE)
G12 = B12 =VLOOKUP(C1,Sheet2!A1:E300,3,FALSE)
etc
0helpful
1answer

Copying data from one sheet to another if two fileds match

Nope, sorry, although I am truly an expert at Excel formulas, I do not understand what you are trying to end up with in the final cell. We can compare a specified field with two spreadsheets - use named ranges and index/match lookup formulas. But then where you really lose me is in reading "a generic field" to find a match, and then placing what "data from another field" into what "other sheet" - ? See the confusion?

Best way to compare 2 given parameters would be to use a nested if formula, with index/match combo. Here is a simple Excel example of how such a formula could be structured:

Sample Data (columnar arangement):
A1: Part B1: Code C1: Price D1: Find Part E1: Find Code
A2: x B2: 11 C2: 5.00 D2: y E2: 12
A3: x B3: 12 C3: 6.00 D3: y E3: 11
A4: y B4: 11 C4: 7.00 D4: x E4: 12
A5: y B5: 12 C5: 8.00 D5: x E5: 11

To retrieve the price for part y with code 12 and return the value to cell F2, type the following formula in cell F2:
=INDEX($C$2:$C$5,MATCH(D2,IF($B$2:$B$5=E2,$A$2:$A$5),0))

Press CTRL+SHIFT+ENTER to enter the formula as an array formula. The formula returns the value 8.00.

To take this one step further, with range names, this example will find one value at a specified location which matches a specific row header value and column header value. Let's say the range is home values (Range=HomeVal), Column A of HomeVal contains street addresses,"row headers" (Range=StAddress), and Row 1 contains dates of the various values that are in the body of the table, "column headers" (Range=Dates). To return the specific value from the range HomeVal to another sheet, where A1=address specified and A2=date specified:
=INDEX(HomeVal,(MATCH($A$1,StAddress,0)),(MATCH($A$2,Dates,0)))

Then make sure to press CTRL+SHIFT+ENTER to enter the formula as an array formula - if you only hit enter, these types of formulas will not work properly.

Please post back if you need further help, with more details, otherwise thank you for using and rating FixYa!
0helpful
1answer

Creating a formula

go to the field with the number of day formula and modify the formula just add to it this *8. The result will be in hrs.
Assuming a holiday uses 8 hrs of pay. It sounds like everyone starts with 25 holiday X 8 hrs or 200 total hours,
Not finding what you are looking for?

76 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...