| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Go to ToolsOptionsTransition and uncheck the "Transition Formula Evaluation"
and "Transition Formula Entry". This is the cause of your problem to start with and further imports should work properly without making changes after the fact. Gord Dibben Excel MVP On Thu, 10 Mar 2005 07:47:05 -0800, "jbsand1001" wrote: 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
