Formatted as financial in the original data tab and the pivot table data area, but alas, the values are displayed as blank fields in the pivot table data area.
Anyone any ideas?
Are you sure they are not text instead value with cell formatted.
If the values are on the left of the cell then they are still formatted as text. If this is the case, then select the column and choose text to columns. Then press ok.