Paste nagative number

P

psturm

Has anyone had a problem cut and paste data from AS400 to excel 2000 sp3 and nagative numbers not showing up?
 
F

Frank Kabel

Hi
how are the displayed in Excel (with a trailing minus -> if yes use
'Data - Text to Columns)
 
P

Peo Sjoblom

That part of DTTC was introduced in excel 2002, he can use a macro like

Sub Conv_Trail_Minus()
Dim cell As Range
For Each cell In Selection.Cells.SpecialCells( _
xlCellTypeConstants, xlTextValues)
cell.Value = CDbl(cell.Value)
Next cell
End Sub


press alt + F11, insert>module and paste the above,press alt + Q to close
VBE,
select the numbers and press alt + F8 and run the macro

or a help column and a formula

=IF(ISNUMBER(FIND("-",A1)),---SUBSTITUTE(A1,"-",""),A1)

However I really don't understand the OP when he says don't show up, are
they not there?
If that's the case I haven't got a clue

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Top