A relatively simple one? I have the following scenario (simplified for use here)

Metric Format Week1 Week2 Week3 Week4 etc
ABC P 1 2 3 4
XYZ W 5 6 7 8

I want to display the number as a Percent if there is a 'P' in column B and as a whole number if there is a 'W' i.e.

Metric Format Week1 Week2 Week3 Week4 etc
ABC P 1% 2% 3% 4%
XYZ W 5 6 7 8

These have to stay as numbers as they are going to be used in a graph, so I can't use =Text(), i'd also like to avoid VBA if possible for a number of different reasons.

I need a formula or conditional formatting method to do this, can anyone help?