I have a suite of reports on 50 excel sheets, calculating data from one main source. The results are in pounds, but I want to convert it to £'000s without the need to use a formula. I am sure there is a custom data format that I could use. Can anybody help?