Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    New Zealand
    Posts
    295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formatting Survey (97,2000)

    I'm looking at excel formats and wonder whether what I am seeing is an aberration or the norm. The toolbar button $ shows currency style on the tooltip but in 97 and 2k applies the accounting style. The difference being the placement of the $ symbol primarily. This has happened on all machines that I have checked. Can others confirm and does anyone know why??? <img src=/S/question.gif border=0 alt=question width=15 height=15> <img src=/S/thinks.gif border=0 alt=thinks width=15 height=15>

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

    Re: Formatting Survey (97,2000)

    Respectively, yes in XL97, and I do not know why.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Formatting Survey (97,2000)

    Mike,

    I think this was discussed on the lounge in early-mid May. The date sticks in my mind bcs I was in a class at the end of May (5/31) where the facilitator remarked about the very same thing. having "just" seen this on the lounge, I was able to tell her why this was. As to why MS did it this way is a mystery that Bill will have to reveal to us. Hopefully our star loungers can dig up the post but here goes the why...

    What you see as the tool tip under the $, % and , is the name of a style. It is NOT how these items are formatted. Click on Format | Style and you will get a Style dialog box. At the top is a Style drop down box. Click the down arrow and choose the style named currency. You will then see various properties of a style definition such as Number, Alignment... On my machine with Xcl97 (and, as I recall, the facilitator's in class which was Xcl2000), only the Number box is checked for the Currency style and it shows you how a number formatted with the "Currency" style will be formatted. If you look at it carefully, you will see what you are observing - the placement of the $-sign follows the accounting style. Now here's the clincher - click the Modify button and you will see that the Number property of the Currency style is formatted as...accounting! You can now change the Number aspect of the Format Cells of the Currency Style to anything you want. A Currency-looking format might be good but you really can do anything.

    But beware. Now that Bill has won his appeal, he could very well turn on anyone who messes with this bit of indirection.

    Of course, the same holds for % and , styles but those are defined in a more logical manner.

    HTH

    Fred

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    New Zealand
    Posts
    295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting Survey (97,2000)

    Thanks Fred for confirming what I thought was the case. A strange one really. <img src=/S/hmmn.gif border=0 alt=hmmn width=15 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
  •