Formatting numbers imported to Ecel

[Don]

I have a column of numeric data imported from another
application. When I apply a subtotal(9, datarange) to data
it retrns zero. If I highlight an idividual number within
the data range I can see the number enclosed by "" - so I
suspect its a formatting issue. Is there any easy way of
changing format without adding new columns? I have tried
formatting as number but that dosen't work ...

Thx,

Don-

 

[Frank Kabel]

Hi
try the following:
- select an empty cell and copy it
- select your imported data
- goto 'edit - Paste Special' and choose 'Add'

as alternative use 'Edit - Replace' and replace all " with
nothing

 

[Bernie Deitrick]

Don,

Excel won't convert the numbers if you simply change the formatting of the
cells.

Select the cells, and use the following macro:

Sub TryNow()
Dim myCell As Range
For Each myCell In Selection
myCell.Value = Val(Replace(myCell.Value, Chr(34), ""))
Next myCell
End Sub

HTH,
Bernie
MS Excel MVP