Questions tagged [currency-format]
Questions dealing with changing regional or global notations or settings of currencies.
22
questions
0
votes
1
answer
6k
views
Chart axis labels — Use $1M (million) short form instead of full $1,000,000 number
I have a PivotChart in Excel 2016 that has dollar amounts as the x-axis.
Currently, the labels are formatted as full numbers. Example: $1,000,000.
Is there a way to format the labels by replacing the ...
- 157
0
votes
1
answer
1k
views
How to format a column as 'currency' and delete the currency present currency string?
My excel file contains a column with numbers and text like this
2,34 EUR
64,34 EUR
9,98 EUR
I want to format the column as a currency.
Currently I delete the 'EUR' text (e.g. manually or with search ...
- 337
1
vote
1
answer
5k
views
How to put Saudi Riyal (SAR) currency symbol in left side of currency?
The default currency symbol format is like this:
But I want the currency symbol to be shown on the left side.
It was #,##0.00 [$ر.س.-ar-SA] in custom formatting before, and I tried changing this ...
0
votes
0
answers
241
views
How to change the currency symbol look of backslash to real backslash look
As you can see in the screenshot above, Python shows me the Korean Currency symbol instead of a real backslash \.
How can I fix this?
3
votes
6
answers
29k
views
Can I change the default currency symbol in Excel 2016 for a single workbook
I'm using Excel 2016 on MacOS High Sierra. I'm based in the UK, and so my global default currency symbol is £. I'm creating a new workbook with forecasts for a European operation, so in that workbook ...
- 4,463
1
vote
1
answer
189
views
Format currency as CNH in Excel
I have some Excel cells in the currency CNH (offshore Renminbi). However, this is not available among the currency choices (Right-click->Format cells->Currency->Symbol). How can I use CNH in the excel ...
- 473
0
votes
0
answers
4k
views
How do I change the currency in an Access database?
I (a British developer) have a database that I am developing for a client in the USA. When I set columns as currency they display with a £ sign. How do I change this so that Access displays a $ sign ...
- 503
2
votes
1
answer
8k
views
How to change default Accounting Number Format?
In most cases, the default accounting format in Excel is $
Without using some kind of macro
Without changing timezone (or other system settings) of the computer
How to change this and set another ...
- 161
1
vote
1
answer
982
views
OpenOffice Calc "if" formula for currencies
I have a spreadsheet that has many different currencies in it ($, euro, shekel). I want to display the actual price in the original currency and then show the converted price (in this case to shekels)...
- 11
1
vote
1
answer
3k
views
Sorting by different currency symbols in Excel 2010
The Accounting Department enters receipts of money in different currencies ($, shekels, & Australian pounds). Is it possible to sort a column containing mixed currencies by currency type if the ...
- 11
0
votes
1
answer
7k
views
Automatically format cells as currency from .CSV when importing into Excel
When I import a .CSV file into Excel, how do I get all cells which contain a number to be formatted as currency? Currently, if the value for the cell contains the dollar sign ($), it becomes formatted ...
- 126
2
votes
1
answer
26k
views
Managing different currencies in Excel budget sheet
I need to enter the values as I write cheques (ie $100 USD and $100CDN, not $111.55 USD and $100CDN) otherwise it will be a nightmare for me to match entries to invoices. I could create a column for ...
- 717
0
votes
4
answers
41k
views
Typing Indian Rupee symbol with Windows 8 keyboard
I bought a Dell Inspiron 15R laptop. I don't know how to use the keyboard to type the new Indian Rupee symbol (₹). I searched Google and found an answer i.e. to hit the right Alt or AltGr key and then ...
3
votes
1
answer
6k
views
How can I get a Euro (€) sign with a MacBook Pro US keyboard in Windows 7?
I have a MacBook Pro running regularly on Windows 7 with direct boot into Windows.
I have a US keyboard but need to use the Euro sign all the time. I haven't managed to find a shortcut that works. ...
- 41
2
votes
1
answer
3k
views
How to convert currencies in Excel based on historical conversion rates?
I want to make a small program in Excel that allows the user to convert certain currencies (USD, Euro, AED, CHF and GBP) to Kuwaiti dinar. The user can set the amount, the currency and the month, and ...
- 21