Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

copy paste people soft

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Copy paste from People soft

Copy paste from People soft

ResolvedVersion 2007

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

Tue 1 Dec 2009: Automatically marked as resolved.

Excel tip:

Copying Formulae Quickly

There is a quicker way of copying a formula down a column.

Just point and double click on the black autofill handle in the right hand corner of a cell.

This will work providing you have some data in the column to the left of the column.

Sandy

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.