Home > IT Answers > AS/400 > CA Express download from iSeries to excel
Help

Question

  Asked: Jun 13 2007   9:57 AM GMT
  Asked by: 283900

CA Express download from iSeries to excel


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.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Jun 14 2007  8:29 AM GMT  by Bradskk




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

Bradskk
  • AddThis Social Bookmark Button

Browse more Questions and Answers on AS/400, Microsoft Windows and Development.

Looking for relevant AS/400 Whitepapers? Visit the Search400.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

chenthil  |   Jun 14 2007  9:29AM GMT

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.