Hi,
I have a drop down list that is linked to some pivot tables, these pivot tables have separate information consisting of costs, production figures and averages. i have 1 cell that displays the results when i click on one of the drop down lists. The problem i am having is that i cannot find a way to display the results correctly automatically, is there a way that the cell automatically updates the format from production numbers without decimal places, to money with decimal places with a £ sign to decimal places without a £ sign. THANKS
Bookmarks