Mainframe Download to Excel has Minus sign at the end of the number

[DoctorV]

The report has positive and negative numbers in columns. The positiv
amounts do not have a sign and are recognized in Excel as numbe
format. The negative amounts have a "-" sign at the end of the number
Excel recognizes these as text format. Is there an easy way t
reformat all the amounts with a negative sign to be recognized a
number format in Excel

 

[Andy B]

Hi Doctor

There are a few ways to do this. I use asap-utilities from
www.asap-utilities.com, but below is a formula way:

=-LEFT(D20,LEN(D20)-1)

Andy.

 

[Frank Kabel]

Hi
try the following
- select this column
- goto 'Data - Text to Columns'
- just click through the wizard and finish the wizard

 

[JE McGimpsey]

One way:

http://www.mcgimpsey.com/excel/postfixnegatives.html

 

[Stephan Kassanke]

you might have a look at this article:

http://www.contextures.com/xlDataEntry03.html#MinusCode

hth,
Stephan

 

[JE McGimpsey]

Note: this works for XL02/03 only.

 

[DoctorV]

Very very helpfu