{"id":53791,"date":"2021-09-22t18:03:37","date_gmt":"2021-09-22t22:03:37","guid":{"rendered":"\/\/www.deco-dalles.com\/?p=53791"},"modified":"2021-09-23t10:55:12","modified_gmt":"2021-09-23t14:55:12","slug":"p6-export-to-excel-number-formatting-secret","status":"publish","type":"post","link":"\/\/www.deco-dalles.com\/p6-export-to-excel-number-formatting-secret\/","title":{"rendered":"p6 export to excel: number formatting secret"},"content":{"rendered":"
we all struggle with the same issue when <\/span>exporting data from primavera p6<\/span><\/a> to <\/span>microsoft excel<\/span><\/a> for analysis, progress updating and graphing. excel does not seem to recognize numbers as numbers!<\/span><\/p>\n that is because p6 formats all data exports as text (appends an apostrophe in front of all data).\u00a0<\/span><\/p>\n