98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Copy paste from People soft
Copy paste from People soft
Resolved · Medium Priority · Version 2007
Tue 24 Nov 2009, 17:41Delegate alex said...
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
Wed 25 Nov 2009, 09:53Trainer Stephen said...
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
Tue 1 Dec 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Quick Zooming in Excel with rollerball mousesTo zoom in and out of your page hold down the control key and roll the wheel up and down. This will zoom up and down 15% at a time. |
