Question about PC Desktops

1 Answer

I have a column of 13000 cells containing id numbers. i want to format the entire column in numbers and eliminate the - (dash) who to do it

Posted by on

  • jcdavid May 30, 2008

    I REALIZE THAT MICROSOFT TEAM IS AVAILABLE TO HELP AND SUPPORT PEOPLE SOLVING PROBLEMS. i TRIED TO REACH YOU BECAUSE AFTER 3 HOURS IT WAS REALLY IMPOSSIBLE TO ME TO FIND A SOLUTION.

    THANK YOU VERY MUCH.

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 19 Answers

I presume you are talking about Excel, but the process is similar in many other programs.

First make sure you have a backup copy of the file just to be safe. The do the following.

1. Higlight the cells you want to remove the dashes from (or the entire columnn if easier)

2. From the Edit Menu select Replace

3. Put a single dash in the the Find What: box and leave the Replace With box empty.

Note: This will search the selected range of cells for dashes and replace them with nothing.

4. Select Replace All and give a second and your done.

Posted on May 29, 2008

  • Jeff Gillis May 30, 2008

    Glad to help. Take Care

×

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 is set my decimal point - i type in 100.5 and it reads 1005 can u help me


If you select the column that the numbers are in, Right hand click on the blues column and select format cells, from the choice select number and add the decimal places you require.
Hope that helps.

Feb 17, 2011 | PC Desktops

1 Answer

My MS Excel vlookup function ASCII type table contains both upper case and lower case letters, characters like ( and % or *, and numbers. It seems to return the numerical equivalent of upper case letters...


Correct a #N/A error blueup_clv.gifShow All bluedrop_clv.gifHide All This error occurs when a value is not available to a function or formula.
  1. Optionally, click the cell that displays the error, click the button that appears ooui1_za06043871.gif, and then click Show Calculation Steps if it appears.
  2. Review the following possible causes and solutions. blueup_clv.gifMissing data, and #N/A or NA() has been entered in its place
    Replace #N/A with new data.
    Note You can enter #N/A in those cells where data is not yet available. Formulas that refer to those cells will then return #N/A instead of attempting to calculate a value.
    blueup_clv.gifGiving an inappropriate value for the lookup_value argument in the HLOOKUP, LOOKUP, MATCH, or VLOOKUP worksheet function
    Make sure that the lookup_value argument (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) is the correct type of value — for example, a value or a cell reference, but not a range reference. blueup_clv.gifUsing the VLOOKUP, HLOOKUP, or MATCH worksheet function to locate a value in an unsorted table
    By default, functions that look up information in tables must be sorted in ascending order. However, the VLOOKUP and HLOOKUP worksheet functions contain a range_lookup argument (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) that instructs the function to find an exact match even if the table is not sorted. To find an exact match, set the range_lookup argument to FALSE. The MATCH worksheet function contains a match_type argument that specifies the order the list must be sorted in to find a match. If the function cannot find a match, try changing the match_type argument. To find an exact match, set the match_type argument to 0.
    blueup_clv.gifUsing an argument in an array formula that is not the same number of rows or columns as the range that contains the array formula
    If the array formula (array formula: A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER.) has been entered into multiple cells, make sure that the ranges referenced by the formula have the same number of rows and columns, or enter the array formula into fewer cells. For example, if the array formula has been entered into a range 15 rows high (C1:C15) and the formula refers to a range 10 rows high (A1:A10), the range C11:C15 will display #N/A. To correct this error, enter the formula into a smaller range (for example, C1:C10), or change the range to which the formula refers to the same number of rows (for example, A1:A15).
    blueup_clv.gifOmitting one or more required arguments from a built-in or custom worksheet function
    Enter all arguments (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) in the function.
    blueup_clv.gifUsing a custom worksheet function that is not available
    Make sure that the workbook that contains the worksheet function is open and the function is working properly.
    blueup_clv.gifRunning a macro that enters a function that returns #N/A
    Make sure that the arguments (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) in the function are correct and in the correct position.

Oct 31, 2008 | PC Desktops

Tip

Deleting Rows & Columns from the table


You can also remove columns or rows from the table. Once a row or column is deleted, it can be undeleted by using Undo command. You can delete the columns or rows or cells by using one of the following ways.
By Table Menu
To delete a row or column by Table menu, follow these steps.
  • Place the insertion point in the column or row that is to be deleted.
  • Click Table menu and then select "Delete" from Table menu, a submenu of Delete is displayed.
  • Select Columns or Rows or Cells command to delete the selected element (column or row or cell) from the table.
By Popup Menu
To delete a row or column by popup menu, follow these steps.
  • Select the column's you want to delete.
  • Right click the mouse, a popup menu is displayed.
  • Select "Delete Columns" command, the selected columns will be deleted.
OR
  • Place the insertion point in the column or row that is to be deleted.
  • Right click the mouse, a popup menu is displayed.
  • Select "Delete Cells" command, "Delete Cells" dialog box is appeared.
  • Select "Delete entire row" to delete a row or select "Delete entire column" to delete a column etc. from the dialog box and click "Ok" button.

on Jan 29, 2010 | PC Desktops

Tip

What is the Registry?


The Registry is a database used to store settings and options for the 32 bit versions of Microsoft Windows including Windows 95, 98, ME and NT/2000. It contains information and settings for all the hardware, software, users, and preferences of the PC. Whenever a user makes changes to a Control Panel settings, or File Associations, System Policies, or installed software, the changes are reflected and stored in the Registry.

The physical files that make up the registry are stored differently depending on your version of Windows; under Windows 95 & 98 it is contained in two hidden files in your Windows directory, called USER.DAT and SYSTEM.DAT, for Windows Me there is an additional CLASSES.DAT file, while under Windows NT/2000 the files are contained seperately in the %SystemRoot%\System32\Config directory. You can not edit these files directly, you must use a tool commonly known as a "Registry Editor" to make any changes (using registry editors will be discussed later in the article).

The Structure of The Registry
The Registry has a hierarchal structure, although it looks complicated the structure is similar to the directory structure on your hard disk, with Regedit being similar to Windows Explorer.

Each main branch (denoted by a folder icon in the Registry Editor, see left) is called a Hive, and Hives contains Keys. Each key can contain other keys (sometimes referred to as sub-keys), as well as Values. The values contain the actual information stored in the Registry. There are three types of values; String, Binary, and DWORD - the use of these depends upon the context.

There are six main branches, each containing a specific portion of the information stored in the Registry. They are as follows:


* HKEY_CLASSES_ROOT - This branch contains all of your file association mappings to support the drag-and-drop feature, OLE information, Windows shortcuts, and core aspects of the Windows user interface.
* HKEY_CURRENT_USER - This branch links to the section of HKEY_USERS appropriate for the user currently logged onto the PC and contains information such as logon names, desktop settings, and Start menu settings.
* HKEY_LOCAL_MACHINE - This branch contains computer specific information about the type of hardware, software, and other preferences on a given PC, this information is used for all users who log onto this computer.
* HKEY_USERS - This branch contains individual preferences for each user of the computer, each user is represented by a SID sub-key located under the main branch.
* HKEY_CURRENT_CONFIG - This branch links to the section of HKEY_LOCAL_MACHINE appropriate for the current hardware configuration.
* HKEY_DYN_DATA - This branch points to the part of HKEY_LOCAL_MACHINE, for use with the Plug-&-Play features of Windows, this section is dymanic and will change as devices are added and removed from the system.



Each registry value is stored as one of five main data types:


* REG_BINARY - This type stores the value as raw binary data. Most hardware component information is stored as binary data, and can be displayed in an editor in hexadecimal format.
* REG_DWORD - This type represents the data by a four byte number and is commonly used for boolean values, such as "0" is disabled and "1" is enabled. Additionally many parameters for device driver and services are this type, and can be displayed in REGEDT32 in binary, hexadecimal and decimal format, or in REGEDIT in hexadecimal and decimal format.
* REG_EXPAND_SZ - This type is an expandable data string that is string containing a variable to be replaced when called by an application. For example, for the following value, the string "%SystemRoot%" will replaced by the actual location of the directory containing the Windows NT system files. (This type is only available using an advanced registry editor such as REGEDT32)
* REG_MULTI_SZ - This type is a multiple string used to represent values that contain lists or multiple values, each entry is separated by a NULL character. (This type is only available using an advanced registry editor such as REGEDT32)
* REG_SZ - This type is a standard string, used to represent human readable text values.



Other data types not available through the standard registry editors include:


* REG_DWORD_LITTLE_ENDIAN - A 32-bit number in little-endian format.
* REG_DWORD_BIG_ENDIAN - A 32-bit number in big-endian format.
* REG_LINK - A Unicode symbolic link. Used internally; applications should not use this type.
* REG_NONE - No defined value type.
* REG_QWORD - A 64-bit number.
* REG_QWORD_LITTLE_ENDIAN - A 64-bit number in little-endian format.
* REG_RESOURCE_LIST - A device-driver resource list.

on Dec 02, 2009 | PC Desktops

1 Answer

When i start my desktop then it shutdown automatically within 1 to 5 minutes. plz give me solution


Hi Ashwani,
The system has been corrupted with viruses. Please install the OS to fix the issue. If your PC doesn't contain any important data, I recommend you to partition and format entire hard-drive and install the OS.

Dec 23, 2010 | PC Desktops

2 Answers

Reformated used HP recovery disc when I restart it says SW build ID different from ID on recovery media


You have 2 options. You can write to Microsoft or to HP about your Issue & they might be able to help about the ID issue. Best I would suggest you buy the OS. ( Full installation Pack) this way you have nothing to worry.

May 11, 2009 | HP Pavilion a1610n PC Desktop

1 Answer

Merging 2 columns in excel of names example F1592&H1592 IN COLUMN G1592 SUE JONES


You need to go into format cells and then merge them together and you should be just fine. Highlight the cells that you wish to merge and then right click and then click on format cells and then merge cells together.

May 05, 2009 | PC Desktops

1 Answer

Gateway Computer .


to unhide th column.
click on the upper most left corner (the box on top of the row1 and column c). the enter spreadsheet should be highlighted. then go to format>>unhide. you should have the column A and B.
as far as the lost numbers. if you did not close the work sheet, you can retrieve them by using the back button on the tool bar. you can't retrieve lost number if you close the worksheet and reopen it again.

Apr 27, 2009 | PC Desktops

2 Answers

Cannot insert columns in excel spreadsheet. Comes up with error cannot shift object off sheet


This error message occurs if the following conditions are true:
  • The option Nothing (hide objects) is selected in the Display options for this workbook section in the Excel Options dialog box.
  • You create an object, such as a cell comment, in any cell in a column.
  • You try to hide the column to the left of the column that contains the object, the column that contains the object, or all the columns to the right side of the column that contains the object. Or, in some cases, you try to insert a row or column in the worksheet.
There are two ways to fix this problem.
Method 1:  Temporarily toggle the option from "Nothing (hide objects)" to All In Excel 2007, temporarily toggle the option from Nothing (hide objects) to All, and then insert the rows or columns as needed. To do this, follow these steps:
  1. In the upper-left corner of the Excel window, click the Microsoft Office button.
  2. At the bottom of the menu, click Excel Options.
  3. Click Advanced from list of options on the left.
  4. Scroll down to the Display options for this workbook section, and then click All under For objects, show:, and then click OK.
Notes To use the keyboard shortcut to toggle this selection, press CTRL+6. 
If these steps do not let you hide rows or columns or insert rows or columns in Excel 2007, try the steps in method 2.
Method 2: Change the position property of the object to Move and size with cells To work around this issue, Excel 2003, Excel 2002, and Excel 2000, change the position property of the object to Move and size with cells. To do this, follow these steps:
  1. If the object is a cell comment, select the cell that contains the comment, right-click the cell, and then click Show Comment or Show/Hide Comments. Note This makes the comment visible.
  2. Move the pointer to the edge of the object until the pointer changes into a white arrow with four small black arrows on the pointer. Then, click the object to select it.
  3. In Excel 2003 and earlier version of Excel, click <object name> on the Format menu. Note In this menu command, <object name> is the name of the object, such as "Comment" or "AutoShape."  In Excel 2007, click Format <object name>.
  4. In the Format dialog box, click the Properties tab.
  5. Click Move and size with cells, and then click OK.
  6. If you want to hide the cell comment again, right-click the cell that contains the comment, and then click Hide Comment.
  7. Follow these steps for each object in the affected column as described in the "Cause" section. When you hide the columns, you do not receive the error message.
For more information, visit the Microsoft Knowledge Base article: http://support.microsoft.com/kb/211769

Nov 06, 2008 | PC Desktops

Not finding what you are looking for?
PC Desktops Logo

Related Topics:

59 people viewed this question

Ask a Question

Usually answered in minutes!

Top PC Desktops Experts

joecoolvette
joecoolvette

Level 3 Expert

5660 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18299 Answers

Are you a PC Desktop Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...