Copying data from Project to Excel

		Microsoft Office Forums > Microsoft Office > Project
Copying data from Project to Excel

FAQ

Thread Tools

Display Modes

12-16-2013, 06:25 AM

OTPM

Windows 7 32bit Copying data from Project to Excel

Office 2010 32bit

Expert

Join Date: Apr 2011

Location: West Midlands

Posts: 981

Copying data from Project to Excel

Hi All
I have a macro which copies data from MS Project to Excel. However with one of the fields Excel tries to guess what the format should be for the data being pasted. For example one field in Project looks like:
2,23,234,345,456,789,678,898,999
but when it is pasted in Excel in converts to:

2,23,234,345,456,789,000,000,000
Has anyone else had this issue and if so how did you overcome it?
Tony

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copying data from sheet with deleted columns creates blanks	ZGreyArea	Excel	1	11-20-2013 10:12 AM
Push data automatically from Acess or Excel to create a Gantt chart in Project	GST2212	Project	3	07-06-2012 12:52 PM
Copying and pasting from Excel	Lorna B	Word	1	03-20-2012 11:58 PM
Copying data from one cell to another automatically	mrphilk	Excel	4	06-10-2010 11:52 PM
Copying text from Excel to Word	Fossils13	Office	1	02-22-2010 08:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:12 AM.