Advertisement
Advertisement
- 1. Gary_Th... 96,766
- 2. tliotta 69,897
- 3. murphey2 42,573
- 4. daveslash 22,975
- 5. _b_h 22,560
- 6. Kdo 17,836
- 7. daveslater 9,199
- 8. momi_sa... 7,500
- 9. rward 7,350
- 10. shalomc 6,744
- 11. ajut400 4,700
- 12. LewisPo... 3,200
- 12. dfke 3,200
- 14. mark_wills 2,500
- 15. bggauth 2,200
- 16. meverest 2,000
- 16. jerryscole 2,000
- 16. jazzIIIlove 2,000
- 16. Programmi... 2,000
- 16. giltjr 2,000
- 16. NJComput... 2,000
- 16. mwvisa1 2,000
- 16. Infinity08 2,000
- 16. dmerrow 2,000
- 16. frankytee 2,000
- 1. tliotta 123,876
- 2. Gary_Th... 96,766
- 3. murphey2 44,873
- 4. _b_h 39,873
- 5. daveslash 33,027
- 6. Kdo 18,236
- 7. daveslater 16,827
- 8. rward 10,100
- 9. shalomc 9,542
- 10. momi_sa... 8,300
- 11. bggauth 5,575
- 12. ajut400 4,900
- 13. WaldenL 3,275
- 14. LewisPo... 3,200
- 14. dfke 3,200
- 16. mark_wills 2,500
- 17. twahelpd... 2,450
- 18. Muflone 2,240
- 19. DaveMon 2,000
- 19. mwvisa1 2,000
- 19. larksys 2,000
- 19. jazzIIIlove 2,000
- 19. Programmi... 2,000
- 19. JHammerer 2,000
- 19. giltjr 2,000
- 19. NJComput... 2,000
- 19. jerryscole 2,000
- 19. dmerrow 2,000
- 19. steveberz... 2,000
- 19. Infinity08 2,000
- 19. meverest 2,000
- 19. frankytee 2,000
| 09.03.2008 at 09:10AM PDT, ID: 23699752 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
User used to be able to copy a column of data and paste to excel which 'reformated' the data
Asked by PVUK in Programming for iSeries / AS400, Microsoft Excel Spreadsheet Software, AS / 400
Tags: IBM, Client Access, 4.3
I have just installed a new laptop for someone on the accounts dept who uses bespoke software from a company called GEAC called System21. This runs over our AS400 system and we use Client Access Express for Windows version 4.3 to interface with it.
The user used to be able to lasso a column of figures which would on some lines would be minus figures written as
6504.34-
She would either select copy or hold CTRL + Insert to copy the column. She would open Excel 2003 and either click Edit - Paste or Shift + Insert to paste this column of data.
On her old laptop this data would be automatically reformated so it was right aligned and the minus sign above would be on the left. It would also have a calculation on the bottom right of the screen in Excel such as SUM=8956.32.
I have checked options in Excel and options in the Client Access programs but can find nothing that looks like it may solve it. I have copied the contents of C:\Program Files\IBM folder to the new laptop but again this doesnt solve it.
I have attached (hopefully) two screen shots, one is of the column of data that would be copied and a screenshot of how Excel accepts and reformats it on her old laptop.
Let me know if you have any questions or want me to try something.Start Free Trial
