Skip to main content

Questions tagged [currency-format]

Questions dealing with changing regional or global notations or settings of currencies.

Filter by
Sorted by
Tagged with
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 ...
WarFox's user avatar
  • 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 ...
Edward Tanguay's user avatar
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 ...
Mike Scott's user avatar
  • 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 ...
Edward Tanguay's user avatar
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. ...
Charleshh's user avatar
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 ...
Zameer Ansari's user avatar
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 ...
puk's user avatar
  • 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 ...
metal gear solid's user avatar
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 ...
Maroom's user avatar
  • 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 ...
curious's user avatar
  • 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 ...
lorenzo-s's user avatar
  • 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 ...
Mathias Bynens's user avatar
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?
Jason Watts's user avatar
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)...
Alan Frazin's user avatar
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 ...
Milan Bastola's user avatar
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 ...
JennieB's user avatar
  • 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 ...
parameswaran.T.K's user avatar
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 ...
User1974's user avatar
  • 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 ...
Adam's user avatar
  • 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 ...
Sandra's user avatar
  • 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?
Shinhu Park's user avatar
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 ...
Jamie Bull's user avatar