hwasilk.blogg.se

In the Custom currencies window, select British Pound Sterling, choose the format you want ( £1,000) and click Apply.Select the range of values (e.g., C2:C8), click on the More formats icon (123) in the toolbar, select More Formats and click on More currencies.In Google Sheets, you can also insert the pound sign into cells by formatting cells as currency. Note: To store the pound symbol as a character in the cell rather than a displayed format, change the cell format to text first. Now you can use the Format Painter to add the pound sign to the rest of the values in Column C.Excel automatically formats the cell as currency. The result is the pound sign inserted in cell C2, before the number. Double-click a cell where you want to insert the pound sign (e.g., C2), and make sure the cursor is positioned before the number.(If you do this often, you might want to automate the insertion with a VBA loop).

You can only insert a symbol in one cell at a time, then copy the symbol to the rest of the cells in the range. In the Format Cells window, choose the Currency category from the right side, click on the drop-down menu for Symbol, select £ English (United Kingdom), and click OK.Īs a result, all numbers are formatted as currency with the pound sign before the number.Īnother way to add the pound sign is to use the keyboard shortcut.Select the range of values (here, C2:C8), and in the Ribbon, go to Home and click on the Number Format icon in the bottom right corner of the Number group.To format numbers in Column C as currency (in GBP), follow these steps: Say you have the following data set with Product Name in Column B and Product Price in Column C. You can insert the pound sign in Excel either by using the currency number format or by using a shortcut. This tutorial demonstrates how to insert the pound sterling sign in Excel and Google Sheets.