Import Export numbers as text

There is something I am not doing right when I try to convert numbers in Excel to text to match the export format from P6 8.2.  My situation: Trying to copy and paste data from an Excel Pivot Table to an exported P6 file.  I am trying to populate fields (columns) for "Drawing Number" (no problem) and Budgeted Labor Hours.  Excel lets me know that the exported hours are formatted as text.  When I try to copy and then convert the pivot table data totext, P6 still refuses to inport the 'numbers as text'.  What am I overlooking?  Thanks.

Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts