Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-16-2013, 06:25 AM
OTPM OTPM is offline Copying data from Project to Excel Windows 7 32bit Copying data from Project to Excel Office 2010 32bit
Expert
Copying data from Project to Excel
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default 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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying data from Project to Excel Copying data from sheet with deleted columns creates blanks ZGreyArea Excel 1 11-20-2013 10:12 AM
Copying data from Project to Excel Push data automatically from Acess or Excel to create a Gantt chart in Project GST2212 Project 3 07-06-2012 12:52 PM
Copying data from Project to Excel Copying and pasting from Excel Lorna B Word 1 03-20-2012 11:58 PM
Copying data from Project to Excel Copying data from one cell to another automatically mrphilk Excel 4 06-10-2010 11:52 PM
Copying data from Project to Excel 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 09:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft