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