alex has attended:
Excel Advanced course
Copy paste from People soft
I copy paste from Peoplesoft9 to a cell in Excel and the format on Excel changes to Currency $US
RE: Copy paste from People soft
Hi Alex
Thank you for your question
When currency data is copied into Excel the format usually matches that of the destination. The fact that it is not suggests an issue with PeopleSoft which I'm afraid we do not support.
You could try pre formating the cells in Excel to a currency format. Alternatively it would be possible to write a macro that would automatically format the data after you had pasted it
Regards
Stephen