Question about Microsoft EXCEL 2004 for Mac

Open Question

Having issues entering data in mac excel spreadsheet using number pad/num lock. first entry in column does not recognize alpha character but enters rest of number, i.e., E1100 will enter 1100 but all cells entered after the first retain alpha entry. Also, on using arrow down, next cell data is automatically deleted prior to any typing entry. On entering a series of numbers, the last one or two are automatically deleted (like backspace) if enter is not immediate. Any ideas?

Posted by on

4 Suggested Answers

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

dbarchitect
  • 150 Answers

SOURCE: HOW TO STRIP DELIMITED CHARACTERS FROM SPREADSHEET

The short of it is this ...
Match the data in each location and store it the same way. As a number or as a string. I would say, looking at your data, that these are probably strings of numbers. Put the apostrophe in front of both pieces of data at both locations so they match. I tried a simple test in Excel and adding the apostrophe in front of all the uses of this data will match everything.

The long of it is this ...
Now, I don't know your technical expertise, but I'll try to put it simply. The hard part to understand in database and data storage, is that not all numbers are numbers.

For example, a phone number 8005551212 is not a number. It's a string of numbers. This is because every single position from the 8 to the 2 is a significant position. Another example is a a social security number. The arbitrary SSN of 002003421 is a string of numbers. The first two 0's will be stripped off in Excel if put in as a number, thus ALL number but be retained in their original significant position.

The apostrophe (added by the user) forces Excel interpret the cell data as a string, instead of number, preserving all the characters in their original form, and doesn't try and tinker with the formatting.

The other reason is that the data you've provided is WAY BIG for a number. Not a lot of systems in the world will do calculations against such big numbers. This is why I "guess" that they should be strings (adding the apostrophe to the front of the data in the cell).

How do you know if data should be stored as a string or as a number. The tall tale question is "will I be using these numbers in calculations." If you do, it's a number, if not, it's a string (add the apostrophe). A second question could be "do I need all positions to retain their original information" as a literal.

Please ask any questions.

Posted on Dec 18, 2007

abhvp
  • 148 Answers

SOURCE: When I type a number into a cell, and then hit

It should. What is the error you are getting? What if you click with mouse to next cell?

Posted on Mar 31, 2009

kd24911
  • 90 Answers

SOURCE: I need a running balance in a column for a petty cash spreadsheet

Hi,

for Column E, if current cell is E(x) and previous cell is E(x-1) then,
formula will be:
=E(x-1) + C(x) - D(x)

logic: C is added to last balance, D is substracted the same way

Hope this helps.

Posted on Jun 18, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How do I turn on and off Num Lock on my Dell inspiron 15


My keyboard does not have a light either. Place the cursor in a place where you can enter characters, like in a text box or Word or Excel. Press one of the number keys on the numeric keyboard, and if a number shows up, the lock is on. If something else happens, or maybe nothing happens, most likely the lock is off. In that case you can press the Num Lock key.again and retry this test.

Jan 27, 2014 | Computers & Internet

1 Answer

1) Contacts details entry - how do you enter uk postal codes which are alpha numeric, when the zip code field only permits numerics via a pop up entry number pad, other tah entering in the city field, eg...


1. In your Input method, under Settings>Locale and Text, you probably are using Samsung Keypad.
- There is a 4th column on the numeric keypad. Press the [?#+] key until it displays the alphabet characters.

2. Unfortunately, at the moment, there are only two available display options - Firstname and Lastname.

Hope this helps.

May 06, 2011 | Samsung Galaxy Tab Tablet PC

1 Answer

What is excel


What is Excel blankxl_250.jpg
Microsoft Excel is a spreadsheet program which allows one to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs, and statistical analysis.

Dec 15, 2010 | Microsoft Office Excel 2003 for PC

3 Answers

Transforming birthdates into year codes


Here is a solution that might work for you. Please be mindful that there are several different solutions that will achieve the same thing in Excel (I am assuming Excel is your software).

1) Make sure each column in your spreadsheet has a heading.

2) Highlight (select) the column of birthdays.

3) Choose Format from the menu bar.

4) Choose Cells... from the drop-down menu.

5) For the "category", choose Custom.

6) In the "type" box, type yyyy

7) Click OK and when you return to your spreadsheet, you will see only the years displayed. However, when you try to edit a cell, you will see that the entire birth date is stored and preserved.

8) Now, highlight the entire table

9) Then, choose Data from the menu bar

10) Choose Subtotals... from the drop-down menu

11) In the "At each change in" box, choose the name of the column with the birth dates

12) In the "Use function" box, choose Count

13) Leave all other choices at their defaults

14) Click OK, and you are done.

Using this method, you can continue to enter the data as you always have. In that way, the birth date info is never actually destroyed or converted. What you are doing is simply deciding what is displayed.

I hope this helps.

Aug 02, 2009 | Microsoft Office Excel 2007

1 Answer

Downloading latitude and longitude


Do you want to enter them manually, or via USB?

To enter a location manually, using only GPS coordinates, try the following: Create any entry in your address book - it doesn't matter what you enter since you will be totally changing it anyway! Then 'edit' the address book entry that you just created, putting what you want in each data field. Finally, edit the GPS coordinates for this address book entry (note that you have to overwrite the whole entry, beginning with N, S, W, E and then the numbers). Save your changes and now you have an address book entry for that rig.

I do not know how to download this directly using the USB connection - sorry.

Jun 29, 2009 | Lowrance iWAY 600C Car GPS Receiver

1 Answer

Autofilter ceases to work on large Excel 2003 spreadsheet


Sounds like there is a gap between the filter heading and the column data. That's the only time I've seen suggested data missing from the drop-down.

Jun 16, 2009 | Microsoft Computers & Internet

1 Answer

Input data


If you want to transfer your data into SAS, SPSS, or some other program, follow these guidelines:
The cells in Row 1 should contain the column's eventual data set name. Each name should be a relatively short and unique acronym that clearly identifies the data. It should begin with a letter and contain only letters, numbers, or an underscore ( _ ) where spaces would naturally fall. Avoid using special characters such as $, &, @, in variable names. Since each row represents the values from one subject, the first column(s) should contain one or more variables that give each subject a unique identifier. They become especially important if you need to merge two or more data files.
In Excel, data formats are defined for a range of cells rather than for a complete column. For this reason it is important that each entire column, including cells with missing or uncollected data, have one, and only one, format. Actually, you do not need to format the entire column, only the portion you will eventually use. Highlight that portion and select the appropriate format from the Format/Cells option. Do not select formats that will enter commas, dollar signs, or other visual enhancements. Numeric, text, and date formats (e.g. mm/dd/yy is often a good choice) are probably the only formats you'll ever need.
The "Split" option (under the "Window" pull-down menu) keeps the row of variable names and the columns of identifiers in view, whatever range of cells in the worksheet you may need to review. First place the cursor at the most extreme upper left-hand corner where data entry begins (e.g., the intersection of Row 2 and the column in the upper left-hand corner where data appear) and then select "Split" from this menu. For any row or column of the worksheet you move to, you'll know exactly which variables you are observing (column names) and their associated ID values (rows).
For versions of Excel later than 4.0, one file can contain multiple worksheets. By default, the tabs at the bottom of these sheets are supplied names ("sheet1," "sheet2," etc.). You can change these names by clicking this space with your mouse and entering a new name. Use the same conventions for first-row variable names: use a short acronym of the page contents that begins with a letter, use only letters or numbers, and enter the underscore ( _ ) where a space naturally falls.

Jan 05, 2009 | Sage Instant Accounts 8.0 (013604ug)

1 Answer

PREVENTING REPEAT ENTRIES IN A RECORD ENTER BOX OR REPEAT ENTRY OF EARLIER ENTRY


The only reference I find is that you may have a duplicate filter. Check the filters and delete the duplicate on.
Also, to create a reliable database, I would use Excel or OOpenOffice, which has a spreadsheet program compatible to Excel.

Download and install the free, open source OpenOffice.org office suite (www.openoffice.org)-- it include a spreadsheet compatible with Excel spreadsheets (along with a good, MS Word compatible word processor, and a good MS PowerPoint-compatible presentation program).

Good Luck,
Joe

Oct 08, 2008 | Microsoft Computers & Internet

2 Answers

Duplicacy in excel sheet


Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.
Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data
Select the entire data and do an auto filter
In column F filter the data by Duplicate and delete all these rows
What remains should be unique data

Dec 19, 2007 | Computers & Internet

2 Answers

HOW TO STRIP DELIMITED CHARACTERS FROM SPREADSHEET


The short of it is this ...
Match the data in each location and store it the same way. As a number or as a string. I would say, looking at your data, that these are probably strings of numbers. Put the apostrophe in front of both pieces of data at both locations so they match. I tried a simple test in Excel and adding the apostrophe in front of all the uses of this data will match everything.

The long of it is this ...
Now, I don't know your technical expertise, but I'll try to put it simply. The hard part to understand in database and data storage, is that not all numbers are numbers.

For example, a phone number 8005551212 is not a number. It's a string of numbers. This is because every single position from the 8 to the 2 is a significant position. Another example is a a social security number. The arbitrary SSN of 002003421 is a string of numbers. The first two 0's will be stripped off in Excel if put in as a number, thus ALL number but be retained in their original significant position.

The apostrophe (added by the user) forces Excel interpret the cell data as a string, instead of number, preserving all the characters in their original form, and doesn't try and tinker with the formatting.

The other reason is that the data you've provided is WAY BIG for a number. Not a lot of systems in the world will do calculations against such big numbers. This is why I "guess" that they should be strings (adding the apostrophe to the front of the data in the cell).

How do you know if data should be stored as a string or as a number. The tall tale question is "will I be using these numbers in calculations." If you do, it's a number, if not, it's a string (add the apostrophe). A second question could be "do I need all positions to retain their original information" as a literal.

Please ask any questions.

Dec 18, 2007 | Microsoft EXCEL 2004 for Mac

Not finding what you are looking for?
Microsoft EXCEL 2004 for Mac Logo

Related Topics:

101 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2727 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18392 Answers

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

Answer questions

Manuals & User Guides

Loading...