Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Reading, Berkshire, England
    Posts
    199
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Currency Icon (2K)

    I have inherited a spreadsheet which formats numbers as "IR

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

    Re: Currency Icon (2K)

    The 'Currency' toolbar button applies the 'Currency' style to the selected cells. Apparently this spreadsheet has its 'Currency' style set to Irish pounds (must be an old one - Ireland has converted to the Euro over two and a half years ago.
    Select Format | Style to view and modify style definitions.

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Currency Icon (2K)

    <img src=/S/jollyroger.gif border=0 alt=jollyroger width=29 height=18> There's something else going on, at least in XL 2003. My Currency Format button now by default sets Accounting Format when it is clicked, on worksheets with General Number Format Style. I have been wondering if Excel tracks the most frequently used format and adopts it adaptively. I have been meaning to link code to the button to force it back to Currency. Time to visit the MSKB.
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Currency Icon (2K)

    <P ID="edit" class=small>(Edited by tony55 on 17-Aug-04 22:58. )</P>Using XL 2003, the currency format button also defaults to the accounting format for me.

    Just checked the Format>Style... options and the Currency style is set to the Accounting format.

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

    Re: Currency Icon (2K)

    Same for me in Excel 2002: the Currency toolbar button sets the Currency style, and this style is set by default to the Accounting format. If I set the Currency style to a different number format, the Currency toolbar button will set the new format.

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Currency Icon (2K)

    Ah, thanks, Tony & Hans. <img src=/w3timages/censored.gif alt=censored border=0> Big Brother Microsoft, trying to tell us what to do. It makes no sense to me to have a Currency Format and an Accounting Format, and then set Currency Style to Accounting Format. Mumble, grumble.

    Maybe now we should help the OP. <img src=/S/blush.gif border=0 alt=blush width=15 height=15>
    -John ... I float in liquid gardens
    UTC -7ąDS

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

    Re: Currency Icon (2K)

    The "inherited" workbook was probably created in the Republic of Ireland, so had its Currency style set to use Accounting format with IR

  8. #8
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Reading, Berkshire, England
    Posts
    199
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: Currency Icon (2K)

    Thanks once again Hans for coming to the rescue. Havve reset my toolbar for this spreadsheet to the default, which on all my normal sheets is Accounting. <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>

Posting Permissions

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