CA Express download from iSeries to excel

5 pts.
Tags:
AS/400
PC/Windows Connectivity
Software
I really really need help finding a solution to this problem. We have users that download files from the iSeries using Client Access Express into excel. The problem is that when the report comes up in excel the negative numbers have the minus sign to the right of the number instead of the left. Does anyone know of a fix to this problem? Our OS is V5R2. Client access is SI23978 and the pc operating system is Windows XP. Please help, I'll be so very grateful.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Have you tried reformatting the cells in the spreadsheet that are recieving the data?

Bradskk

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • chenthil
    Hi, could you please check the file whether the Negative sign is for the same column or for next column, i guess the negative sign is for next column, while doing the import wizard in excel please check the columns carefully. suggestion : do the data transfer again and while opening with excel, care full with column breaks please let me know the result.
    465 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following