The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Copy paste from People soft

Resolved · Medium Priority · Version 2007

ReplyTue 24 Nov 2009, 17:41Delegate alex said...

Copy paste from People soft

I copy paste from Peoplesoft9 to a cell in Excel and the format on Excel changes to Currency $US

For upcoming training course dates see: Pricing & availability

ReplyWed 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.

Excel articles

· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Improve Performance Of Your Excel Macros
· Tools From Advanced Excel Courses: Goal Seek and Solver
· The Secret Formula To Creating Correct Calculations In Excel
· Is It Time For You To Trade Up To Excel 2010?

Please browse our web site to find out more about
excel computer training and other Microsoft training courses.

Excel tip:

Formst Excel to display leading zeroes

Select the cells that you want to have displaying leading zeroes.

From the 'Format' menu select 'Cells' (Or Right-click on the selected range and and select 'Format Cells').

In the 'Number' tab click on 'Custom' in the 'Category' window.

In the 'Type:' box enter zeroes that correspond to the size of the required number (eg 5 zeroes).

Click OK.

When you enter numbers into these cells, leading zeroes will be displayed.

eg 123 = 00123

View all Excel hints and tips

Dear Richard,

In reply to your email, my boss told me that the way to do a percentage in excel for me to work out how much the rent is for the current month is to do =1785+1785*3/100 and this will give me the correct answer to how much the rent actuall..

» Forum post: Excel

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions