Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Feb 2004
    Location
    London, Gtr London, England
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cell Format (Excel 2000 SR-1)

    Wondered if anyone could help me out. I need to know how to change the shortcut that formats cells into a specific currency. Currently if I press Ctrl + Alt +4 it formats cell info into UK Sterling, I want it to format that info into US Dollar. Any help/ideas would be great !! Cheers

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cell Format (Excel 2000 SR-1)

    Welcome to Woody's Lounge!

    As far as I know, Excel takes the currency from the Regional and Language Options control panel. If you specify US$ as currency there, Excel will use this setting, but so will most other Windows applications.
    If you don't like that, you could record a macro to set US currency format, and assign it to a keyboard shortcut or custom toolbar button. If you put the macro in Personal.xls, it will be available in all workbooks. (If you don't know what Personal.xls is, see Legare Coleman's <!post=Personal.xls Tutorial (All),118382>Personal.xls Tutorial (All)<!/post>.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Cell Format (Excel 2000 SR-1)

    Are you sure it isn't Shift-ctrl-4?

    What are your windows regional settings for currency? I think the currency selected is based on those settings. Do you have it set for "English(United Kingdom)"? Change it to "English (United States)"

    In XP you get to regional settings
    Start - ctrl panel - "Date, time, language and regional settings"
    Regional and language options - Regional options
    Choose: "English (United States)"

    Steve

  4. #4
    New Lounger
    Join Date
    Feb 2004
    Location
    London, Gtr London, England
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cell Format (Excel 2000 SR-1)

    Cheers Hans, this worked fine. Thanks alot.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •