excelformatdefaultaccounting
Change the default accounting format in excel
In latest version of excel the default accounting format (Home > Number) is dollars, in the dropdown you get the GBP sign but i cant find anyway to change it to the default button. I have checked every language setting i can find on the PC and in office and they are all set to UK or English (not USA)
Any ideas!
Solution
Click the drop down near $ sign and click more accounting formats
select the GBP Symbol UK as per image
- Subscript out of range error looping through rows and columns in Excel VBA
- Why I could not simply read sheets and merge all the content in a single Variant?
- VBA ByRef argument type mismatch in Excel 2019
- How to find average per day using pivot table?
- control method of worksheet is not available
- Copy sheet and get resulting sheet object?
- Increment number in an alphanumeric string
- When checkboxes are ticked, captions should be put in a comma separated string and be placed into an array
- A formula to find both text in asterisks and find text next to parentheses
- Finding missing numbers in a preset range
- Adding Module through code
- VBA Excel - identify duplicates and rearrange them
- Display FILTER results in the same order as the values in the criteria range
- Odd behavior when looping through files in a folder
- ag-grid - Define custom column header values while exporting to Excel/CSV
- Excel cannot import a CSV file containing fields with multiple lines
- QT Excel - Open to Read/Write
- Screenshot of a range in Excel, which is then saved as a PNG file
- XLOOKUP with flexible column and search criteria which is not unique
- Read and store the values from Excel rows to variables/arrays using VBscripting in UFT
- Excel Macro or VBA for Copy and pasting text
- Excel - Pass Multiple Arguments to a Function as a Single String
- Display only the Top5 values from SORT function
- Create a list with SORTING and FILTER function with multiple criteria in a range
- Power Query document not saving changes
- Excel SUM function is not working (shows 0), but using Addition (+) works
- How to do aggregations while preserving the same number of rows?
- Excel Dynamically Expanding Table
- Find most recent value/ value at the bottom of column based on criteria
- Calculate SUM if criteria appears in a string in the criteria_range