The issue happens because Excel’s Stocks data type sometimes treats LSE prices as dollars instead of pence/GBP, so a stock like Aston Martin at 60.30 pence shows as $60.30. To fix it, click the small card icon that appears after converting the cell to Stocks, then check the data card for a “Price in GBP” or similar field to get the correct pound value. If that option isn’t available, Excel treats pence as pounds internally, so you would need to divide by 100 to display the correct price.