Currency Format


  1. gusz
    Posts : 10
    Windows 7
       New #1

    Currency Format


    I'm in Mexico and I have Windows 7 and Office 2007, both in spanish. In Excel,
    my currency format displays in Euros, with commas as the thousands separator.
    I want Mexican pesos as the currency, and period as the thousands separator.
    I've tried installing the spanish (Mexico) language pack in Windows 7, and setting
    pesos (Mexico) as the currency in Excel Options under the Office Button, but
    I can't seem to get it right.

    I'm guessing that somewhere I'm configured as if I'm in Spain, not Mexico, but
    I can't figure out how/where. Can someone step me through how to configure
    this correctly in Windows/Excel, or point me to a link how to do this?

    Thx, Gus
      My Computer
    Quote Quote

  3. Irene
    Posts : 3,009
    Windows 7 Home Premium 64bit
       New #2

    Here is the solution for the Thousands separator:

    By default, Microsoft Excel uses the system separators that are defined in the regional settings in Control Panel. If you sometimes need to display numbers with different separators for thousands or decimals, you can temporarily replace the system separators with custom separators.

    1. Click the Microsoft Office Button , and then click Excel Options.


    1. On the Advanced tab, under Editing options, clear the Use system separators check box.
    2. Type new separators in the Decimal separator and Thousands separator boxes.

    Tip When you want to use the system separators again, select the Use system separators check box.
    Note For a permanent solution, you must change the regional settings in Control Panel.
    When you say that you want Mexican pesos as the currency, do you want to see $ or MXP as a prefix?
    Attached Thumbnails Attached Thumbnails Currency Format-separators.png  
      My Computer
    Quote Quote

  4. Irene
    Posts : 3,009
    Windows 7 Home Premium 64bit
       New #3

    To display the currency, you need to format the cell(s) like this - also adjusting the decimal point for denominations below one peso:
    .
    Attached Thumbnails Attached Thumbnails Currency Format-currency.png  
      My Computer
    Quote Quote

  6. Neutron16
    Posts : 934
    Windows 8.1 ; Windows 7 x86 (Dec2008-Jan2013)
       New #4

    Try to configure settings Control Panel -> Region and Language.
    In Format tab set Spanish (Mexico)

    MS article in Spanish
    same article in English
      My Computer
    Quote Quote

 

  Related Discussions
The weather and currency gadget on my laptop is not working but is working fine on my desktop. I have tried the APPDATA files thing, Disableing/reenabling the gadget service as well as AV and firwall, redownloading the gadget, and almost every other trick I saw that worked for other people but...
My currency format is displaying xxx.xxx,xx. It's really messing up my financial software (Quickbooks). I have gone into the control panel/Regional and Language Options/Customize Regional Options/Currency and found it is set up incorrectly. However, I'm unable to change the settings to xxx,xxx.xx....
Currency Gadget
in Customization

Windows 7 Professional versions: I have one PC that loads the Currency Gadget with "Bad Number!" each time. The other PC loads the last number used "1". How can I get the Bad number! to default to 1? had the same problem with RC version.
Currency issues
in General Discussion

I have recently changed to a new computer. My old one was set up in the US, but I now reside in Greece. I have both US and Greek bank accounts and do internet banking. The old computer used Windows XP whereas the new computer is on Windows 7. Today I went on line to my US bank account and found...
How to Change Currency Format in Windows 7 and Windows 8 This tutorial will show you how to change the regional currency format to how you want it to display in Windows 7 and Windows 8. Here's How: 1. Open the Control Panel (icons view) in Windows 7 or Windows 8, and click on the...
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 01:29.
Find Us