Data Import & Export

Fix Excel for the Web Storing GBP Currency Values as Text

Adam Davis Oct 19, 2026 868 views

Question details

The user needs to prevent Excel for the web from storing pasted financial data with British Pounds (GBP) or other non-US currencies as text instead of calculable numbers.

How to Fix Excel for the Web Storing GBP Currency Values as Text

Product: Excel for the web
Device & OS: not provided
Scenario: Copying and pasting financial data containing GBP or other non-US currency symbols into an online Excel workbook.
Observed behavior: The pasted currency values are formatted as General text instead of numbers, meaning they cannot be totaled or calculated in the worksheet.

Before you start

Ensure your web browser is updated to the latest version and verify the default regional formatting settings applied to your Microsoft 365 account.

Solution 1Recommended

Adjust Regional Format Settings in Excel for the Web

Change the workbook's regional settings to match the currency being pasted so that the symbols are recognized as valid numerical values.

Excel for the web relies on cloud regional settings, which often default to the United States. When pasting a currency symbol like £ (GBP) into a US-formatted workbook, the application fails to recognize it as a number and converts it to text. Updating the region resolves this conflict.

Open Regional Settings

Open your workbook in Excel for the web, click on 'File' in the top ribbon, select 'Options', and then click on 'Regional Format Settings'.

Select the Target Region

Click the dropdown menu and change the region to English (United Kingdom) or the region that matches your specific currency. Click 'OK' to apply.

Contact M365 Admin if Settings Revert

If the region reverts to the United States after reloading the page, ask your organization's Microsoft 365 Administrator to change the default regional format for your user profile in the admin center.

Admin Privileges Required for Default Changes: While you can change the regional setting for an active session, a permanent change to your default cloud region must often be executed by an IT administrator.

Solution 2

Paste as Unformatted Values and Apply Formatting

Bypass the regional conflict entirely by pasting raw numbers and applying the currency format within the online workbook.

Solution 3

Convert Existing Text to Numbers via Desktop Excel

Fix data that has already been pasted and incorrectly stored as text by utilizing the desktop application's error-checking tools.

Format Currency Data Accurately with WPS Spreadsheet

Avoid web browser regional conflicts by managing your financial data in WPS Spreadsheet. WPS Office relies on your system's local regional settings and offers robust cell formatting tools, ensuring your currency values are always recognized as calculable numbers.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open your financial workbook from your local drive.
2. Paste the data as unformatted text: Copy your financial data, right-click the destination cell in WPS Spreadsheet, and select 'Paste Special' > 'Unformatted Text'.
3. Apply local currency formatting: Select the pasted cells, right-click to choose 'Format Cells', navigate to the Currency tab, and select GBP (£) or your preferred currency symbol.

Fully compatible with Microsoft Excel files (.xlsx, .xls, .csv)Accurate offline currency formatting without web regional conflictsEasily convert text to numbers with a single clickLightweight desktop app that avoids browser-based syncing issues

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel for the web store my copied numbers as text?

This happens when the currency symbol in the copied data (like £) does not match the default regional settings of your online Excel workbook (which often defaults to U.S. Dollars). Because Excel fails to recognize the foreign symbol as a valid number format for that region, it defaults to storing the cell as plain text.

How can I quickly convert text to numbers in a spreadsheet?

If you are using a desktop application like Microsoft Excel or WPS Spreadsheet, you can highlight the affected cells, click the warning indicator that appears, and select 'Convert to Number.' Alternatively, you can use the VALUE() formula in an adjacent column to extract the numeric value.

Will changing my regional settings in Excel for the web affect other users?

If you change the regional format settings under File > Options in your own Excel for the web view, it only affects your current view. However, if your Microsoft 365 administrator changes the default region for the organization, that change will apply to all users within the tenant.

Can I use Ctrl+Shift+V to fix the currency formatting issue?

Yes. Using Ctrl+Shift+V (or choosing 'Paste as Values') pastes only the raw numeric data without the original text-based currency symbols. Once pasted as plain numbers, you can safely apply the correct currency format using the spreadsheet's toolbar.

Excel & Data Problems