# 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.

×

• 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

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

×

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).
Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### Cell number sequence

Sequencing is a formula =A1+1. If you insert a cell you can re-s
equence by doing a autofill in the column that contains the sequence number.
i.e.
Cell A1 value= 1
Cell A2 =A1+1 (value will be 2)
If you auto-fill the entire column will sequence:
=A2+1 (value will be 3)
=A3+1
etc.

Jul 03, 2017 | The Computers & Internet

### In Excel adding positive and negative numbers

Yes,

1. Select the column. (click on top of the column it will select)
2. Right Click and select Format Cells.
3. Select Currency in Category then press OK
Now just type your Numbers i.e. 571 for \$571 and -650 for -\$650 and sum using the normal way.

That is Select the Cells which you want to SUM and Press Alt+=

This will bring the total just below the selected cells.

Thanks
Iqbal

Apr 02, 2008 | Computers & Internet

### How do I set up excel to change the background of a cell as the information within the call changes?

Conditional formating should be able to this. But how is your data organized? (Column headers, Row headers etc.)

Oct 20, 2014 | Microsoft Excel for PC

### Sum numbers in a column down until you come to a blank, then start again

Sounds like your issue can be solved readily with a pivot table.
If you give the columns of names a title like "NAME" and the number columns a name like "VALUE". All other columns should contain a unique name.

Then select the entire table, including the labels at the top ensuring that the range extends entirely over the column you need to sum the values of.

In Excel 2013, choose the INSERT menu and select the PIVOT TABLE command.
Insert the Pivot table into a new worksheet.
A new sheet will open with a strange-looking control panel on the right of the window.
Make sure that the box for NAME and VALUE (only) are checked

You will notice that Excel assumes that you want the SUM of the values for each NAME summed. The results are in the leftmost area of the worksheet.

Sep 03, 2014 | Microsoft Excel for PC

### Autosuggest Possible to use in Excel

As long as your list in Excel is formatted without missing cells in column format with a header in the cell directly above your first list time. i/e if your list is in Column A and you have 500 entries, I am assuming Cell C1 is the column header, and cell C501 is the last item of your list.

An easier way to view items similar would be to go to Data/ Filter and automatic filter.

In the arrow or list format in Cell c1 - select custom, in the pop up box you can filter the contains to highlight smaller elements of your list.

May 01, 2009 | Microsoft Excel 2003 (065-03992) for PC

### Copy formulas

It should work if you just copy and paste it. Or select the range of your working area and right click in destination cell and choose paste special. When new window pop up, just choose Formula.

It should work usually, but by any chance you've encountered the problem regarding this. Just let me know...i'll try to help you...

Mar 23, 2009 | Microsoft Office Excel 2003 for PC

### Conditional formating to highlight problems.

in Excel 2007 and if you have a cell (say C2) with the value of elapsed time (for example set = A2 which contains start time plus B2 which contains end time - or current time) - click in the cell (C2) then on the Home tab click on Styles >> Conditional formatting choose Highlight Cells Rules>>Greater Than... set your value in the dialog to your respective value and choose your highlight. This is a start - you can then add new rules.

to then apply this same conditional formatting to every cell in that column Ctrl-C to copy the cell you just formatted - then click on the column header to highlght the entire column - Right-click and choose Paste Special - then choose Formatting for what to paste.

It's slightly different in Excel 2003 so let us know what version you are using.

Cheers.

Feb 27, 2009 | Microsoft Office Standard for PC

### 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)

### 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.

Nov 06, 2008 | Computers & Internet

### How to change the date format?

Select the cell or column or range containing the date(s). Click Format -> Cells On the Number tab, click Date This will give you the various formats available. The default date format is determined by the settings in the control panel. Windos XP: Control Panerl -> Date, Time, Language and Regional Options -> Change the format of numbers, dates, and times -> Customize This dialog box has tabs for Numbers, Currency, Time, and Date. There you can select the default formats for how you want things to appear. Hope this helps.

Sep 08, 2007 | Microsoft Office Standard for PC

## Open Questions:

#### Related Topics:

60 people viewed this question

Level 3 Expert

Level 3 Expert