Questions tagged [currency-format]
Questions dealing with changing regional or global notations or settings of currencies.
22
questions
40
votes
5
answers
299k
views
How to type pound sign(£) using US keyboard, in Windows, Linux and Mac?
I have dual boot configuration with Fedora and Windows XP. Keyboard is normal US standard keyboard. Now that I am working for a UK based client, I need to use pound sign quite often. Currently I am ...
- 612
5
votes
4
answers
59k
views
How can I remove the space between dollar sign and value in Excel cell?
I have some cells labeled as euros and some as dollars.
For some reason the dollar sign is left-justified with a space between it and the value.
The cell is right justified.
How can I get the ...
- 14.2k
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
3
votes
4
answers
12k
views
With German regional settings, how to display some cells in U.S.-currency-format e.g. $1,000.00?
My Windows 7 has regional settings set for German/Germany.
This causes currency values in Excel to appear like this:
234.234,00 €
However, sometimes I want currency data in a cell to appear like ...
- 14.2k
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
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
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
2
votes
2
answers
5k
views
How to change currency on webpage if my currency not available on the website? [closed]
For example this in an Indian website http://compareindia.in.com/products/monitors/
All prices on page are in INR (currency of India), is there any plugin/add-on on any browser which can change the ...
- 8,924
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
1
vote
1
answer
187
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
1
vote
1
answer
6k
views
Filtering by currency in Excel
I have this situation in Microsoft Excel:
Cells are formatted by using "Format Cells" and setting the Currency manually for each cell. So, they are not simple strings. I would to sum filtering by ...
- 191
1
vote
2
answers
2k
views
Show the currency symbol *before* the number in OS X
I’m using the latest Mac OS X (10.6.4).
It’s possible to customize the currency notation in System Preferences › Language & Text › Formats.
However, it doesn’t seem to be possible to choose ...
- 2,461
1
vote
3
answers
8k
views
Format a Word 2007 table to display currency values
When I apply a formula to the table, it allows me to select a format. How do I apply a currency format on the numbers to the other cells in Word 2007?
- 211
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
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 ...
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
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 ...
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
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
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
0
votes
0
answers
240
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?
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