| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I delete the "=" from a cell to give me the phone number I.
I have some data that I copied off a website and pasted into an excel
spreadsheet but I do not get the value that is displayed on the website. For example.... The information that was copied was a phone and fax number 1-555-555-5555 but when I put this information into my excel sheet I get -4500. If I look into the cell the cell looks like =1-555-555-5555. I need a way to remove the "=" from each one of these cells. Thank You, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you delete a cell then shift cell up? | Excel Discussion (Misc queries) | |||
| Triangle symbol in cell. What does it mean. How do I delete this | New Users to Excel | |||
| Delete Cell Value Based on Another Cell T or F | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| How do you delete one cell from a range of protected cells | Excel Worksheet Functions | |||
Threaded Mode
